Question about IF function

  • Thread starter Thread starter excel_21
  • Start date Start date
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.
 
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
 
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
 
Back
Top