=A1*(1+B1)
whe
A1 contains 100
B1 can contain 20% or -2%
Regards,
KL
"accountingfreak"
<accountingfreak.1slzac_1122098753.3825@excelfor um-nospam.com wrote in
message news:accountingfreak.1slzac_1122098753.3825@excelf orum-nospam.com...
Suppose there is a number is 100
Problem 1: The amount is decrease by 2%
Problem 2: The amount increase to 120
Conditions: 1. No hard-coding.
2. Use just ONE formula. This is to ensure that the
formula created is flexible. Can the formula increase the price by 6%?
Can the formula decrease 100 to 80?
Thanks. Your help is highly appreciated.
--
accountingfreak
------------------------------------------------------------------------
accountingfreak's Profile:
http://www.excelforum.com/member.php...o&userid=25510
View this thread: http://www.excelforum.com/showthread...hreadid=389554