corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » excel formula help » Post Reply

Post Reply
Who Can Post? All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help
Insert Bold text Insert Italicized text Insert Underlined text Insert Centered text Insert a Hyperlink Insert Email Hyperlink Insert an Image Insert Code Formatted text Insert Quoted text
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
Post Options: Disable smileys?
Turn BBCode off?
Receive email notification of new replies?

Bart

 posted on 14th Sep 06 at 11:47

you beat me to it.

thanks guys


Bart

 posted on 14th Sep 06 at 11:47

ha, got it..

=E10-(E10*0.425)


Dan B

 posted on 14th Sep 06 at 11:46

The truth is in the wording of the question...

- If you want to reduce the original value, A1, TO 42.5% of the starting-value, then:

=A1/100*42.5

- If you want to reduce the original value BY 42.5% of the starting-value, then:

=A1-(A1/100*42.5)

------------------

With a starting-value of 200, the top version gives 85; the bottom version gives 115.


Bart

 posted on 14th Sep 06 at 11:45

yes, but i want to reduce the figure by 42.5%, not reduce it to 42.4%

sorry, i didnt explain it well


Tommy

 posted on 14th Sep 06 at 11:41

=D7/100*42.5

85 is correct.

0.5 is 50%

[Edited on 14-09-2006 by LoudandLow]


Bart

 posted on 14th Sep 06 at 11:32

i have £200 in there, which i want to reduce by 42.5%

i have A1*0.425 and i get £85! that aint right.
but if i do A1*.5 i get £100 which is correct :boggle:


Bart

 posted on 14th Sep 06 at 11:29

strange... gives me a different figure.

the cell A1, also is a formula, but has an amount in


blebo

 posted on 14th Sep 06 at 11:13

=A1*.55


James

 posted on 14th Sep 06 at 11:09

=A1 - ((A1/100)*45)

Try that


Tommy

 posted on 14th Sep 06 at 11:09

DOne u just divide by 100 then times by the percentage ?


Bart

 posted on 14th Sep 06 at 11:07

im trying to deduct a cell by 45%

what i have done is:
=(a1 - 0.45)

and it doesnt seem to do the trick, ive also tried: -(a1 - 45%)

any have any suggestions?