I am trying to complete a tracking spread sheet that needs to work within upper and lower bounds, such as If x is less than 100 and great then 50, then --, else --. The manuals that I have access to and the online help screens in excel haven't been any help.

Does anyone out there have a good handle on how to construct this kind of statement?

Thanks!

Mike