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?

1. Select the cell where you want to display the result.
2. Type the following formula in the formula bar:
   
   
   Code:

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

3. Press Enter to apply the formula.

This formula uses nested IF functions to check if the value in cell E17 is below the range (less than C17), above the range (greater than D17), or within the range (between C17 and D17).

If the value in E17 is less than C17, the formula will return "Below Range". If the value in E17 is greater than D17, the formula will return "Above Range". If the value in E17 is between C17 and D17, the formula will return "In Range".

You can adjust the cell references in the formula to match your specific data range.

You could do this:

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

Assumes that C17 is less than D17.

Hope this helps.

Pete

On Jul 31, 1:44*am, 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?

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

"Pete_UK" wrote:

You could do this:

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

Assumes that C17 is less than D17.

Hope this helps.

Pete

On Jul 31, 1:44 am, 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?

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.

--
Rick (MVP - Excel)


"Max" wrote in message
...
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

"Pete_UK" wrote:

You could do this:

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

Assumes that C17 is less than D17.

Hope this helps.

Pete

On Jul 31, 1:44 am, 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?

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?