The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> Excel Formula for subtracting 10% - any ideas?
Post Info TOPIC: Excel Formula for subtracting 10% - any ideas?
Johnny


Newbie

Status: Offline
Posts: 2
Date:
Excel Formula for subtracting 10% - any ideas?
Permalink  

Hi,

I would like a formula that allows me to subtract 10% off a value.  I've tried several times, and no luck so far!!!

Many thanks in advance.

Johnny

www.bicalsocks.co.uk

__________________
Nimac


Senior Member

Status: Offline
Posts: 137
Date:
Permalink  

May be a bit long winded but here goes.

In column A type the number you want to subtract from eg 100

In column B type the formula =A1*10%, this will give the value 10

In column C type the formula =A1-B1, this will give the value 90 which is 100 minus 10%

Then right click on the B at the top of column B, select hide and this will hide the 10 but still work out the correct result in Column B.

If anybody else has an easier way, let me know.

__________________
Dustin57


Senior Member

Status: Offline
Posts: 125
Date:
Permalink  

You could also use the following formula:

=sum(A x 0.9)

E.G. Orginal amount is £500, 10% off would be, =sum(500x0.9) = 450 i.e. 90% of the original amount.



__________________
"People who are exceptionally good in business arent so because of what they know but because of their insatiable need to know more"
Johnny


Newbie

Status: Offline
Posts: 2
Date:
Permalink  

You good people!!!

Many thanks, and have a good day.

Regards

Johnny

www.bicalsocks.co.uk

The best product for kids learning to crawl & walk aged 6-18 months.

Go take a look!



__________________
AccountantsCircle


Senior Member

Status: Offline
Posts: 164
Date:
Permalink  

Why not just...

=A1*0.9

Where A1 is the amount.

__________________

John Gesch
The Accountants Circle
Online Tools & Excel Templates | Online Map Directory | Accountant & Bookkeeper Blogs
Nimac


Senior Member

Status: Offline
Posts: 137
Date:
Permalink  

Alot simpler than my method!!!



__________________
BRADY


Newbie

Status: Offline
Posts: 1
Date:
Permalink  

=A1*0.9 simple and worked. A bit puzzled though. How do you get 10% out of 0.9? Suppose it doesn't really matter as it did the job!

__________________
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink  

BRADY wrote:
=A1*0.9 simple and worked. A bit puzzled though. How do you get 10% out of 0.9? Suppose it doesn't really matter as it did the job!
It is just a different way of saying 90/100 (= 9/10 = 0.9), which is the same as saying 100% - 10% =90% (=90/100)

Bill

 



__________________

 

 
GrahamG


Veteran Member

Status: Offline
Posts: 53
Date:
Permalink  

@Dustin57 there is no need to use the SUM function for an arithmetical formula in XL. As John says, just go for =A1*0.9; in this case, the SUM function is actually doing nothing in your formula.


If I'd got hear earlier, I would have suggested:

A1: 100

B1: =(A1-(A1*10%)) - a few characters more, but a completely readable / understandable formula.


GrahamG

__________________
ICBUK


Guru

Status: Offline
Posts: 833
Date:
Permalink  

On the subject of Excel, has anyone tried the Excel with Business course? Do you have any feedback?

Details:

http://www.bookkeepers.org.uk/News/976

__________________

Kind regards

Anna

Best International Association Winner

Institute of Certified Bookkeepers 
0845 060 2345
www.bookkeepers.org.uk

Facebook 
Twitter
YouTube
LinkedIn
Google Plus

 

 

 
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> Excel Formula for subtracting 10% - any ideas?
Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About