Excel Percentage Query

peterattheboro · 10 Mar 2010 at 14:25

Currently I have a formula...

=SUM(E37-0.25*E37)

E37 contains the total 2120.

Now I'm deducting 25% from this which is 530.

How do I get that formula to show 530 intead of 1590?

Hope that makes sense.

Cheers

SiriusB · 10 Mar 2010 at 14:35

What are you trying to do? If you want to know what 25% of E37 is, the "0.25*E37" bit will do that. Your formula is finding 75% of E37. Which is more easily written as E37*0.75

JimboJet · 10 Mar 2010 at 14:40

That got me too when I first looked at it. Your original formula was correct. I think what you are trying to ask (and get displayed as a cell field) is "how much is 25% of E37?" (2120 / 100) x 25

This is simply "=E37*.25"

peterattheboro · 10 Mar 2010 at 17:42

SiriusB said:
What are you trying to do? If you want to know what 25% of E37 is, the "0.25*E37" bit will do that. Your formula is finding 75% of E37. Which is more easily written as E37*0.75

Whilst having my head full of numbers and formulas, it turns out that your very very simple suggestion is actually genius.

Thanks

JimboJet said:
That got me too when I first looked at it. Your original formula was correct. I think what you are trying to ask (and get displayed as a cell field) is "how much is 25% of E37?" (2120 / 100) x 25

This is simply "=E37*.25"

Thank you to

SiriusB · 10 Mar 2010 at 18:26

peterattheboro said:
Whilst having my head full of numbers and formulas, it turns out that your very very simple suggestion is actually genius.

Thanks

I have days like that! Head so full of information you can't see the solution that is right in front of you!

You're welcome