Greater than or equal to IF statement

[Hoosier03]

I am using excel 2007. I am trying to write an IF statement where if a number is between 4.12 and 5.50 it stays the same. If the number is below 4.12 then it is 4.12. If it is above 5.50 then it is 5.50.

=IF(AND(I88>=4.12,I88<=5.5),I88,'[Natural Gas Pricing FY12 13_Reprice from 7-26-2011.xlsx]Sheet1'!$H$29)

This is what I have so far. [Natural Gas Pricing FY12 13_Reprice from 7-26-2011.xlsx]Sheet1'!$H$29) refers to the cell that is 5.50. This returns all numbers above or below as 5.50. I need to return the numbers below 4.12 as 4.12.

Thanks,

Rodney

 

[Scott Huish]

You don't need IF, you need MEDIAN:

=MEDIAN(4.12,I88,$H$29)

 

[Hoosier03]

That worked thanks.