32CARDS
Board Regular
- Joined
- Jan 1, 2005
- Messages
- 123
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
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