ExcelBanter - IF formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF formula (https://www.excelbanter.com/excel-worksheet-functions/165502-if-formula.html)

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

On Nov 9, 11:20 pm, Tee@EEOC
wrote:
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?