Help
I'm fairly new to Excel but I understand the basics except when it comes to setting up calculation columns, I have an immediate need for the following calculation.
In Col A I have a list of figures, in Col B I want to deduct say 25% from the list in Col A & then again in Col C I want to deduct 33.% from the fig in Col A.
But what I need is the ability to change the % values in Col's B & C when rq'd & have excel automatically update it's answers in those Columns.
A B C
Value Less 25% Less 33.3%
1 198 142.56 132.06
2 208 156 138.73
3 145 108.75 96.71
Can anyone lead me through this step by step ?
SKT
Last edited by Suurkarvanetupp; 09-14-2009 at 04:26 AM.
b1
=A1-0.25*A1 so put
in say d1 0.25
then
=A1-d1*A1
or
=A1-d1*A1
format cell d1 as %
then put 25 in d1
Last edited by martindwilson; 09-13-2009 at 09:12 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martin when I said the basics I really meant the basics.
Can you talk me through what I need to do please.
Just to clarify in case I did not make myself clear
Col A will have a list of amounts, Col B needs to deduct in a percentage form from Col A & that % could be whatever, same with Col C, D or however many Cols I need.
For example if Col B is 25% off & I then type 35% I need the whole of Col B to update to show everything as a 35% reduction on every amount that is in Col A
I hope I'm making myself clear
Assume the values start in A2.
In B1 put the percentage reduction for that column, e.g., 25%
In B2 and copy down, =(1-B$1)*A2
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Re: Percentages
Perfect SHG
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks