IF formula

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

Guest

I am using an IF formula in a column (AM2 - AM133). Here is a sample
=IF(O58=1,"$1000.00",IF(O58=2,"$500.00",IF(O58=3,"$250.00","$0.00")))

It works fine, but when I went to do a basic SUM on the column...it is not
letting. How do I get sum for column AM?
 
You are returning text values instead of numbers by wrapping them in
quotes - leave the quotes off, like this:

=IF(O58=1,1000,IF(O58=2,500,IF(O58=3,250,0)))

Format the cell as Currency with 2 dp to get the appearance you want,
and then copy down.

Hope this helps.

Pete
 
Back
Top