Help - if, and, or plus whatever else I need!

[Mace]

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

 

[etaf]

can this be in a new column , if not then vba needed - not my area

=IF( A3 >=1.03, 1.03, IF( A3<=1.01, 1.01, A3))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=MEDIAN(A3,1.01,1.03)

 

[Mace]

Hi, thank you both for such prompt replies. ETAF - that appears to have worked. Thanks again!

 

[etaf]

you are welcome