adding range of numbers to if statement with three criteria

[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

 

[Frederik]

Hi Mifty

Hope this will do it:

=IF(AL12<-5,"q",IF(AL12>5,"p",1))

 

[Guest]

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.

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

 

[Guest]

Works like a dream !

Thank you Frederik

 

[Guest]

Brilliant Thank you

--
Mifty

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