Multiple IF

P

Phippsy

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

Guest

Hi

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

Hope this helps.
Andy.
 
Top