ExcelBanter - Multiple IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple IF (https://www.excelbanter.com/excel-worksheet-functions/69834-multiple-if.html)

Phippsy

Multiple IF

Is there a way of creating an IF function resulting in many options such as:
B36 "High"
B3 Between 6 and 0 "Low"
B3<0 "Negative"

Multiple IF

Hi

Try something like this:
=IF(B36,"High",IF(B3<0,"Negative","Low"))

Hope this helps.
Andy.

"Phippsy" wrote in message
...
Is there a way of creating an IF function resulting in many options such
as:
B36 "High"
B3 Between 6 and 0 "Low"
B3<0 "Negative"

Phippsy

Multiple IF

Excellent thanks

"Andy" wrote:

Hi

Try something like this:
=IF(B36,"High",IF(B3<0,"Negative","Low"))

Hope this helps.
Andy.

"Phippsy" wrote in message
...
Is there a way of creating an IF function resulting in many options such
as:
B36 "High"
B3 Between 6 and 0 "Low"
B3<0 "Negative"

Multiple IF

Thanks for the feedback!

Andy.

"Phippsy" wrote in message
...
Excellent thanks

"Andy" wrote:

Hi

Try something like this:
=IF(B36,"High",IF(B3<0,"Negative","Low"))

Hope this helps.
Andy.

"Phippsy" wrote in message
...
Is there a way of creating an IF function resulting in many options
such
as:
B36 "High"
B3 Between 6 and 0 "Low"
B3<0 "Negative"

All times are GMT +1. The time now is 09:39 PM.