Reputation: 1
=IF(ISBLANK(Q3)," ",Q3-O3) I want to check if a cell is blank or not and then if it is blank, leave it as such and if it isn't, assign the difference.. The problem is, it isn't identifying the blank space in the True Condition,the False condition( Assigning difference) works like a charm.
ANY FIXES anybody?
Upvotes: 0
Views: 973
Reputation: 285
=IFERROR(TRIM(Q3)-TRIM(O3),"")
i.e, if the difference cannot be calulated (casues an error), then leave the result be a null (empty) string.
... and as usual, this cannot be entered in any of the referenced cells (Q3 and O3 here).
,
or ;
between parameters - depends on your environment / locale
Upvotes: 0
Reputation: 5195
ISBLANK(A1)
returns TRUE
only if cell A1
is truly blank. Note that if cell A1
evaluates to blank, (e.g. if cell A1
contains = ""
), ISBLANK(A1)
returns FALSE
.
A1=""
returns TRUE
if the cell is truly blank or if the cell evaluates to blank. I assume this is what you want in this case. Maybe try:
=IF(Q3="","",Q3-O3)
Upvotes: 1
Reputation: 23
Since you are attempting to do “math”, you could use if(IsNumber(Q3), Q3-O3, “”). Also, an empty string has NO SPACES, not sure why you’re adding a space in your formula.
Upvotes: 0
Reputation: 1271
I guess you are saying that Q3 is containing a space? Why not just IF (ISNUMBER(Q3);Q3-O3;"") ?
Upvotes: 0