% In Excel

  steviegee 09:21 25 Oct 2007
Locked

I want to make a spreadsheet where I enter a cost in A1 say £25.00 then make a formula so that in B1 it adds 25%, C1 it adds 30% and so on to about 60% . What are the formulas please?

  johnnyrocker 09:30 25 Oct 2007

what about using the 'if' formula?




johnny.

  steviegee 09:34 25 Oct 2007

Don't know anything about 'If' !!!

  exodus 09:40 25 Oct 2007

Hi, or just put your cost in A1.
In B1, to increase the whole cost by 25%, use the formula
=A1*0.25+A1

In C1, a 30% increase, the formula will be
=A1*0.30+A1

and so on. You just change the percentage multiplier in each formula.

exo

  xania 09:47 25 Oct 2007

I think you can do this most simply with a formula in the top row of each column and then copy this down each row as needed:

B1=A1*1.25
C1=A1*1.30
D1=A1*1.35
etc

or you could work with constants but that woul dbe more of a steam-hammer approach.

  steviegee 09:49 25 Oct 2007

Thanks

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?