Formula for returning multiple criteria

[chris007]

Hello,
Newby here so please be patient.

I am attempting to return a word dependent on the value outcome, can someone here please assist me.

the formula a have documented is

=IF(G10>15,"Extreme", IF(G10<15,"Moderate", IF(G10<7,"Low")))

The formula works in regards to returning the Word Extreme and Moderate however Low returns the word False

I m looking for Moderate where the value is between 7 and 15 and the word low where the value is below 7

I am using Microsoft Excel 2010

Thank you Snoopy007

 

[Desu Nota from Columbus]

=IF(G10>15,"Extreme",IF(G10<7,"Low","Moderate"))

 

[Desu Nota from Columbus]

Welcome to the forum!

 

[VoG]

Try either

=IF(G10>15,"Extreme", IF(G10<7,"Low", IF(G10<15,"Moderate")))

or

=LOOKUP(G10,{0,7,15},{"Low","Moderate","Extreme"})

 

[chris007]

Thanks,
that worked perfectly

I Know this may sound silly but are you able to help me understand why my formula did not work.

Thanks Again

 

[Desu Nota from Columbus]

The ordering of the statement. By putting G10<15=Moderate second, you stated that all values less than 15 were moderate (even though you added later that less than 7 is Low).

Excel steps through the if statement: If(Value1, {is true do this}, {is false do that}) You stated that if the value of G10 were above 15 make "Extreme". If value were not above 15 (or false), then if less than 15 make Moderate. For all values less than 15, G10<15 would be true therefore "moderate" will be the returned value.

 

[chris007]

thank you all makes sence