Telling the difference between zero and blank in IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an IF statement that needs to chooses the range of cells from which to
perform a calculation based on whether or not a certain cell has a value.
There are times when the value in this cell needs to be Zero. The problem
is, Excel treats 0, "0" as a blank (as in >=0, >="0"). It worked when I
turned the cell containing the key value to text, but then another formula
reading this cell doesn't work. Help!
 
=IF(ISBLANK(A1),"",IF(A1>=0,"Yes","No"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Zero if zero yet blank if blank? 5
How to count the maximum number flanked by zeros 9
Counting blanks as zeros 1
Blank Cells vs. Zero Values 2
Formula - If Statement with blank 3
Displaying zeros in cells 2
COUNT BLANK AND ZERO AS THE SAME THING 6

Back
Top