Percent Formula required please.

[32CARDS]

This is suppose to be a simple math question, but I've forgotten.

Search a reliable online percent calculator which not only shows the result, but the formula, and have not been able to find it, it was once there when googled.

I need to use a formula in Excel to lower a value by a variable percent


A1 Value = 1.70

A2 Value = 20 ( percent_ decrease ) I need to have this seperate because
it's a Variable, but default is 20, as in 20%

A3 Value is where the Formula to calculate 1.70 - 20% = 0.34

A4 Value ought to show 1.70 - 0.34 = 1.36

A5 Value is 1.36 rounded up to show 1.40

I require the A5 value



I also need the reverse, in the B column range, Increase by 20%

How do I make these percent calculations in A3 and A5 ( decrease) and
in B3 and B5 ( Increase) ?

I used this online calculator, but I need the formula
http://www.math.com/students/calculators/source/3percent.htm
Thanks

 

[AlanY]

Excel 2012
	A
3	0.34
4	1.36
5	1.40
Sheet1

Cell Formulas
Range	Formula
A3	=A1*A2/100
A4	=A1-A3
A5	=ROUNDUP(A4,1)

 

[millhouse123]

to add 20% multiply by 1.20% to decrease by 20% multiply by 80% or 1-% to decrease by..

 

[32CARDS]

AlanY,
Thanks,
that's exactly what I was trying to remember, each cell has a use in "what-if" scenarios for some tests.

millhouse123
Thanks,

I think there will be one more percent formula required later, have to implement this solution first and test a few things