Using IF and adding Currency

[mrsbrannon]

Hello all,


Is it possible to write an IF formula that would add currency to a cell? (currency that can be summed, not just the appearance). I've tried but all I can get it to do is put the data, not the $$.

Current formula is:

=IF(C2="Bonus","$40.00","")

I have also tried:

=IF(C2="Bonus", DOLLAR(40),"")

Neither of these work when adding it to other amounts on my table.

Thanks!

 

[philwojo]

Try this maybe:

[COLOR=#333333]=IF(C2="Bonus", DOLLAR(40,2),"") [/COLOR]

 

[jtakw]

Try this maybe:

[COLOR=#333333]=IF(C2="Bonus", DOLLAR(40,2),"") [/COLOR]

I don't have an answer yet, but that produces a Text result, OP needs the result as Number for other math.

Although, I don't see why OP don't just Format cell as Currency?