Good morning,

I have been helping the boss do a spreadsheet that has been very, very formula heavy. I'm a basic Excel user, so these formula's are not the easiest things in the world to complete correctly. I have finally gotten most of them in, but there's one that I'm working on now that's giving me a hard time.

=MIN (b4*12-25%,b4*12-500) + (c4*12-25%,c4*12-500) fills in b18 for me with the correct answer, but I can't figure out how to make the figure show up in the cell. Let me illustrate:

The first part of the formula is to take either the b4 amount times 12 minus 25% --if this amount is less than or equal to 500 then that figure should be used. If it is more than 500 then 500 should be used.
(b4*12-25%)
234.25 * 12 = 2811
2811 * 25% = 702.75 Since this amount is more than 500, 500 should be used instead. ~~this is actually the amount that I want to show in the cell, the amount saved~~
2811 - 702.75 = 2108.25 ~~this is the answer that is showing up in the cell, which is not quite what I need. ~~

I am getting the correct answer, but I want to show the savings of 702.75 + 702.25 in the cell, not the total. How do I make the formula show me the result that I want? Please help...