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
 

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

I am trying to use the IF and SUMIF function on Excel 8
Minus Zero 11
Gretaer Than Zero Formula Question 5
Formula 1
Counting Blank Cells 5
Excel 2003 - VBA - Handling Varible Format 2
Conditional Formatting assistance 7
Excel Formula 1

Back
Top