IF function less than and greater than help.

[i.r.smith]

I've got it started in cell J3 and the first part works I need to add the 2nd and third item below.

IF H3 IS = OR LESS THAN 3 make J3 needs to = 32.00
IF H3 IS GREATER THAN 3 make J3 needs to = 38.00
IF H3 IS GREATER THAN 6 make J3 needs to = 55.00

I'm not sure if it was attached to this but it's at the link below
http://thegallery.us/temp/AcrylicBox.xlsx


Thanks for any help with this!

[JohnTopley]

Try

=IF(H3<=3,32,IF(H3>6,55,38))

[i.r.smith]

Thanks for your help.