i need a formula

  • Thread starter Thread starter Robina
  • Start date Start date
R

Robina

I'd like to be able to use a formula in excel to tell me

COST PRICE + 80% OF THE COST PRICE TO GIVE A NEW TOTAL.

EG: 10 + 8 = 18

10 = COST PRICE
8 = 80% OF THE COST PRICE
18 = RESULT

I'm sure this is simple. can anyone help?
Robina
 
Hi Robina,

The new total is:
=CostPrice*1.8
you don't even need to calculate the intermediate value, unless you need to display it.
 
Hi Robina

The generalised formula to do this is
Cost Price * (1 + Percentage)

With cost price in A1
=A1*(1+80%)
 
Back
Top