Using the "If" function in an Excel formula

  Abel 11:53 09 May 05
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 05

Something like this:

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

  stlucia 12:32 09 May 05

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 05

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

  Abel 18:01 09 May 05

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.

What is Google Allo? What is Google Duo? Google Allo UK release date and features: Google Allo is…

1995-2015: How technology has changed the world in 20 years

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…