Hi All
Am hoping someone can help. I am trying to create a formula to help with rent reviews. Essentially there is a cap and a collar i.e. a minimum and maximum. What I want to formulate is the following - if cell A3 is >= 1.03, then 1.03 should apply. If cell A3 is <=1.01, then 1.01 should apply. If call A3 is greater than 1.01, but less than 1.03, then cell A3 should remain as it is.
I hope I have explained this properly - any help would be greatly appreciated
Am hoping someone can help. I am trying to create a formula to help with rent reviews. Essentially there is a cap and a collar i.e. a minimum and maximum. What I want to formulate is the following - if cell A3 is >= 1.03, then 1.03 should apply. If cell A3 is <=1.01, then 1.01 should apply. If call A3 is greater than 1.01, but less than 1.03, then cell A3 should remain as it is.
I hope I have explained this properly - any help would be greatly appreciated