adding range of numbers to if statement with three criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

Existing if statement

=IF(AL12=0,1,IF(AL12<0,"q","p"))

I would like to amend this to say that if AL12 is between -5 and 5 return 1
if less than -5 return q and greater than 5 return p.

Is this at all possible?

Thanking you in advance
 
Mifty said:
Existing if statement
=IF(AL12=0,1,IF(AL12<0,"q","p"))

I would like to amend this to say that if AL12 is between -5 and 5 return 1
if less than -5 return q and greater than 5 return p.
Click to expand...

=if(AL12<-5, "q", if(AL12>5, "p", 1))
 
Back
Top