Formulas - Ugh!
Hi Bryan
With Market Rent in A1, Current Rent in B1
=MIN(A1,B1*1.03)
--
Regards
Roger Govier
"Bryan" wrote in message
...
Hi there, First time poster - please bear with me...
Here is what i am trying to do:
Market rent = 1200.00 Current rent = 1170.00.
I want to have a formula that takes the current rent, adds 3% if below
market rent without going over market rent. If the sum of current
rent+3% is
over market rent then it calculates at 2.5% or brings the current rent
to
market rent unless it is equal to more than 3%.
Here is the formula I'm using
=IF(G50<F50,ROUNDUP(G50*0.03,2)+G50)
?????(G50F50,ROUNDUP(G50*0.025,2)+G50)
Not sure how to do this (??? unknown transition)
Thanks in advance for any help you can give!
Bryan
|