View Single Post
 
Old 01-31-2018, 02:16 AM
Mihai Vultureanu Mihai Vultureanu is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jan 2018
Posts: 1
Mihai Vultureanu is on a distinguished road
Question Empty cells with formulas

Example:
In column D I have a formula like: if(column C >0;hello;"").
But, unfortunately, although the cells seem to be empty actually excell does'nt treat them as empty. Example: if you select the column from first cell to the last one with contains and you do it by pressing ctrl+shift+down arrow, your empty cells will be also selected.
So: do you have a solution in order to treat empty with formulas cells as though they are really empty?

Thank you,
Mihai Vultureanu
Reply With Quote