Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default If function with 3 different outcomes

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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: If function with 3 different outcomes

  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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default If function with 3 different outcomes

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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default If function with 3 different outcomes

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?



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default If function with 3 different outcomes

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?






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default If function with 3 different outcomes

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF formula with 3 possible outcomes Aaron Hodson \(Coversure\) Excel Worksheet Functions 8 November 8th 07 05:52 PM
#N/A outcomes in formulas Caroline Excel Discussion (Misc queries) 2 August 29th 07 03:33 PM
formula outcomes biker man Excel Discussion (Misc queries) 2 August 29th 07 01:07 PM
256 possible outcomes MarkN Excel Discussion (Misc queries) 9 June 28th 06 08:33 AM
best and worst outcomes xela1986 Excel Worksheet Functions 1 April 24th 06 11:27 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"