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?
what about using the 'if' formula?johnny.
Don't know anything about 'If' !!!
Hi, or just put your cost in A1.In B1, to increase the whole cost by 25%, use the formula =A1*0.25+A1In C1, a 30% increase, the formula will be=A1*0.30+A1and so on. You just change the percentage multiplier in each formula.exo
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.25C1=A1*1.30D1=A1*1.35etcor you could work with constants but that woul dbe more of a steam-hammer approach.
This thread is now locked and can not be replied to.
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 ?
© Copyright 2017 IDG UK. All Rights Reserved.