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"

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"

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"

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"