Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|