dimanche 1 avril 2018

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?

Aucun commentaire:

Enregistrer un commentaire