As written you formula does not work for me but:

=MIN((B4*12)*25%,B4*12-500)&" + "&MIN((C4*12)*25%,C4*12-500)

returns the 702.75 + 705.75 result that you are looking for.

I don't understand:

2811 * 25% (702.75)= 2108.25


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"txheart" wrote in message
...

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:

=MIN (234.25*12-25%, 234.25*12-500)
235.25 * 12 = 2811
2811 * 25% (702.75)= 2108.25

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




--
txheart