Using the "If" function in an Excel formula

  Abel 11:53 09 May 2005
Locked

How can I distinguish between a blank cell and cell with zero value in it when writing an "If" formula. 0 and "" have exactly the same effect.

Abel

  Number 7 12:09 09 May 2005

Something like this:

=IF(ISBLANK(A1),"Empty",A1)

  stlucia 12:32 09 May 2005

You need to use nested if statements -- the first to determine if it's a blank or a zero (as suggested by Number 7) and the second to do whatever you want with the content:

=IF(ISBLANK(A1),"",=IF(A1=0,do something,do something else))

  stlucia 12:34 09 May 2005

Correction, you don't need the second = sign.

  Abel 18:01 09 May 2005

Thank you Number 7 and stlucia for your help. I really must study the various functions more carefully.

Abel

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017