Here's another similar formula:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Max" wrote:

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