I am new to using and creating function in Excel so please bear with me.

I have created a sheet that will allow a user to input a number (this will
be a load in pounds) divide it by a certain factor and show the result. This
part is complete and working fine (thanks to some of you). Now what I would
like to do is have that result compared to a chart and have the result from
the chart display (I have managed to get this to work somewhat by using
=IF(C36<=5.25,"1 PLY 2x4",IF(C36>=10.5,"2 PLY 2x4"))

What I can't figure out is if C36 is less than or equal to 10.49 but greater
than 5.25.
If I end up with a number like 7.25 then I get a "False" response. I have
searched and searched the help files but I am hopelessly lost at this point.

Any help would be greatly appreciated

Thanks,
Joe