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


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author excel formula help
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
14th Sep 06 at 11:07   View User's Profile U2U Member Reply With Quote
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?
Tommy
Member
Registered: 24th Aug 00
Location: Essex, Colchester
User status: Offline
14th Sep 06 at 11:09   View User's Profile U2U Member Reply With Quote
DOne u just divide by 100 then times by the percentage ?
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
14th Sep 06 at 11:09   View User's Profile U2U Member Reply With Quote
=A1 - ((A1/100)*45)

Try that
blebo
Member
Registered: 18th Apr 02
User status: Offline
14th Sep 06 at 11:13   View User's Profile U2U Member Reply With Quote
=A1*.55
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
14th Sep 06 at 11:29   View User's Profile U2U Member Reply With Quote
strange... gives me a different figure.

the cell A1, also is a formula, but has an amount in
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
14th Sep 06 at 11:32   View User's Profile U2U Member Reply With Quote
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
Tommy
Member
Registered: 24th Aug 00
Location: Essex, Colchester
User status: Offline
14th Sep 06 at 11:41   View User's Profile U2U Member Reply With Quote
=D7/100*42.5

85 is correct.

0.5 is 50%

[Edited on 14-09-2006 by LoudandLow]
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
14th Sep 06 at 11:45   View User's Profile U2U Member Reply With Quote
yes, but i want to reduce the figure by 42.5%, not reduce it to 42.4%

sorry, i didnt explain it well
Dan B
Member
Registered: 25th Feb 01
User status: Offline
14th Sep 06 at 11:46   View User's Profile U2U Member Reply With Quote
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
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
14th Sep 06 at 11:47   View User's Profile U2U Member Reply With Quote
ha, got it..

=E10-(E10*0.425)
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
14th Sep 06 at 11:47   View User's Profile U2U Member Reply With Quote
you beat me to it.

thanks guys

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Formula for Excel Adam General Chat 13 503
24th Sep 03 at 19:29
by Adam		  
Excel Help Darren General Chat 3 701
4th Mar 04 at 11:51
by ipswichcorsa		  
excel help Darren General Chat 3 920
28th Jan 05 at 15:04
by VegasPhil		  
Computer Question seanreay1986 General Chat 3 601
1st Mar 05 at 22:53
by seanreay1986		  
is there a program that...... chris_uk Geek Day 6 1904
16th Jun 05 at 00:47
by Dan B		  

Corsa Sport » Message Board » Off Day » Geek Day » excel formula help 28 database queries in 0.0119629 seconds