Help with IF please

  • Thread starter Thread starter Mike Saffer
  • Start date Start date
M

Mike Saffer

Greetings,

I need to show a currency value (cents and partial cents) in some cells when
other cells contain a certain weekday name. I can get it to work, but when
I try to total the currency, I get zero.

Lets say,
A B
Wednesday .044
Thursday .088
Friday .132

Here's my formula entered in B1 and copied down:
=IF(A1="Wednesday",".044",IF(A1="Thursday",".088",IF(A1="Friday",".132",""))
)

I get a zero when I try to sum B1:B3 in cell B4.
Should I be using a lookup table?

Thank you for any help.
Mike
 
mabye something like this
=.044*if(a1="Wednesday",1,if(a1="Thursday",2,if(a1="Friday",3)))
 
Mike - get rid of the " aroud your numbers. ".044" should
be .044. You turn the numbers into text with the "" and
since text can't be added up....
 
Back
Top