Maybe

=IF(B1<1,A1*(1+B1),A1+B1)

so it handles a percentage increase of less than 100% as per KLs post, but
if B1 1 then it just adds it.

As I sit back and wait to be vilified too <G

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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