If function with 3 different outcomes

[Max]

How to use the IF function to get 3 different outcomes. If E17<C17 then
"Below Range", If E17>D17 "Above Range" IF E17 is between between C17 AND D17
then In Range.. How do i do this?

 

[Pete_UK]

You could do this:

=IF(E17<C17,"Below range",IF(E17>D17,"Above range","In range"))

Assumes that C17 is less than D17.

Hope this helps.

Pete

 

[Max]

I may have typed in wrong, however, excel corrected my mistake and the
formulas worked. Truely appreciate the help Pete, saved me a lot of time just
now. take care

 

[Rick Rothstein]

You should consider using Copy/Paste to put posted formulas and/or code into
Excel instead of relying on typing what you (think you) read from the
screen.

 

[Shane Devenshire]

Here's another similar formula:

=IF(E17<C17,"Below",IF(E17>D17,"Above","In"))&" Range"