Question about IF function

E

excel_21

I would like to have every cell in column A that has value of "0.00"
be changed to "NO" and every cell that is > 0.00 to have number values
changed to "YES". What would the formula be?

Thanks in advance.
 
J

JE McGimpsey

Not sure why you're thinking IF() function.

If you just want to display "YES" or "NO", choose
Format/Cells/Number/Custom and enter:

"YES";;"NO";@

Otherwise
 
S

Shane Devenshire

Hi,

An IF formula would read like this

=IF(A1=0,"NO","YES")

You would enter this in cell B1 and copy it down as far as necessary. Of
course you haven't handled values <0.

Cheers,
Shane Devenshire
 
Top