how can i add a pecentage on to a total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

G JONES - 28 Oct 2004 08:23 GMT

I NEED TO ADD A PERCENTAGE TO A TOTAL COST TO TAKE THE FINAL FIGURE FROM COST
PRICE TO RETAIL PRICE

Reply to this Message

VENKAT - 28 Oct 2004 08:55 GMT

suppose total cost is 4500
in anohter cell= the above cell*15%
will give you 675/=
is this what you want ??

> I NEED TO ADD A PERCENTAGE TO A TOTAL COST TO TAKE THE FINAL FIGURE FROM
> COST
> PRICE TO RETAIL PRICE

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

GERWYN JONES - 28 Oct 2004 09:09 GMT

THANKS FOR YOUR REPLY
I WAS HOPING TO BE ABLE TO CONTAIN THE TOTAL OF THE FIRST CELL AND THE ADDED
PERCENTAGE OF IT IN THE NEXT CELL

> suppose total cost is 4500
> in anohter cell= the above cell*15%
[quoted text clipped - 4 lines]
> > COST
> > PRICE TO RETAIL PRICE

Reply to this Message

Alex Delamain - 28 Oct 2004 09:41 GMT

If the original price is in A1 and the percentage to be added is 17.
then in A2

=A1*1.175

Alternatively if you only want to do this once and just keep the ne
value:
Type 1.175 into any blank cell and copy it. Then highlight the price
to be increased. Use Edit, Past Special, and select Multiply then OK
This will multiply all the highlighted cells by the amount copied

Reply to this Message