G.MAANOJ
G.MAANOJ

Reputation: 1

Using IF condition in EXCEL

=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

Answers (4)

Hannu
Hannu

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

ImaginaryHuman072889
ImaginaryHuman072889

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

Versalytics
Versalytics

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

Roemer
Roemer

Reputation: 1271

I guess you are saying that Q3 is containing a space? Why not just IF (ISNUMBER(Q3);Q3-O3;"") ?

Upvotes: 0

Related Questions