View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Need the minus amount to show

b4*12-25% does *not* subtract 25% from b4*12.

25% is simply 25/100 or 0.25. Therefore, to Excel, your formula is:

=b4*12-0.25

That's why you are getting the results you are getting.

Next, to get the best results, you should proofread your posts before
hitting send. Then you won't be confusing potential problem solvers. I'm
sure in your last line you meant to say:
2811 - 25% (702.75)= 2108.25

Subtracting 25% of a number is the same as multiplying by 75%. Therefore, to
get the results you want, change your formula to any one of:

=b4*12*75%
=b4*12*(1-25%)
=b4*12*(1-0.25)
=b4*12*0.75

Do the same for the rest of your formula

Regards,
Fred.

"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