Please might I have help with a formula for the following:
Col A contains 25
Col B contains 28
Col C contains 15
I need to add 25 to 28 and from the total minus 15 as a percent, i.e. AplusBminus15%
I'm sure it's elementary but I'm grateful if anyone can help
Many thanks
Try
=(A1+B1)*(1-C1/100)
Fabulous!
Thank you - what does that "1-" do. I recall it now from years ago and never then understood why it works! That can be considered a rhetoric question if the explanation is tedious.
Many thanks again
If you are subtracting 15% from the total this is the same as multiplying the total by 85%.....1-C1/100 gives you 85% where C1= 15
Ah ha! Yes. Thanks, thanks!
I need to make one column a percentage of a column next to it without typing the formula in every cell. Example. I need each cell in column d to be 90% displayed in column c.
Hi indatser,
Welcome to the forum, but...............
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
Last edited by oldchippy; 08-14-2010 at 06:17 PM.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks