adding a percentage

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

I know this is going to be an easy solution but right now
it is driving me nuts!

I have a worksheet that I use to calculate freight
charges, in each column I have the amount that Fed Ex
charges us to ship a package. But, they also charge a
fuel rate which changes each month it could be 6% or 2%.

What I need is a solution to keep the solid frt charges
the same but add the fluctuating percentage. Currently I
have the percentage in a cell by itself (say cell a8) and
the frt chg in cell a1. I tried using =a1+a8 but rather
then adding on 6% it addes on 6 cents! What can I do??
 
Hi

If your rate is just a normal number (like 8, as opposed to 8%) try this:
=A1+(A1*A8/100)
to make your 8 into 8%
 
Hi Wendy,
You have the fuel rate percentage in A8, and the 'normal' charge in A1
To get the current rate you need to add to A1 a percentage of A1, so you
need =(1+A8)*A1

Bernard
 
Back
Top