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"
|