Thread
:
Need the minus amount to show
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Need the minus amount to show
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann