You are not providing what you want to occur if the value in C36 is between
5.25 and 10.5. Let us know what you want in the event of "7.25"...
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"http://" wrote in message
...
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