How to Get Results to Format as Currency

[Maureen5433]

Hi All,

I have this formula which I created by taking a similar formula found here and modifying. It seems to be working.

=IF(AND(C2<=4),"90", IF(AND(C2>=4,C2<=15),"405", IF(AND(C2>=15),"700","")))

The idea is to automatically calculate a dollar amount into D2 based upon cell contents of C2

If c2 is 4 or less, then D2 = $90.00
If c2 is greater than 4 but less than or equal to 15, then D2 = $405.00
If c2 is great than 15 then d2 = $700.00

So first, do I have this right formula-wise?
Second, I will have a few lines of this and then need to total the results in D. Right now when I do that, it returns a zero or an error. I have tried formatting all different ways and have also tried changing the way the D2 results are displayed via my formulate (eg: 90, 90.00, and $90.00) but nothing works. Do I need to somehow put the formatting into my formula? Basically, it seems as though Excel isnt recognizing the results of my formula as a number or anything else.

Thank you all so much. I have been absent for a long time, mostly because I returned to school but I remember that everyone was very helpful. I greatly appreciate any assistance you can provide.

 

[DonkeyOte]

You're presently returning the values as strings "90" rather than 90 hence format / summation issues

Also - your bands technically overlap though they contain unnecessary tests

=IF(ISNUMBER(C4),IF(C4<=4,90,IF(C4<=15,405,700)),"")

format cells as Currency

 

[VoG]

Try

=IF(AND(C2<=4),90, IF(AND(C2>=4,C2<=15),405, IF(AND(C2>=15),700,"")))

or

=DOLLAR(IF(AND(C2<=4),90, IF(AND(C2>=4,C2<=15),405, IF(AND(C2>=15),700,""))),2)

 

[Maureen5433]

First "DUH" to me...or should I say DUH?

Second -thank you to all of you. I am moving again.