adding range of numbers to if statement with three criteria
 

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

adding range of numbers to if statement with three criteria
 

Hi Mifty

Hope this will do it:

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


"Mifty" schreef in bericht
...
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

adding range of numbers to if statement with three criteria
 

"Mifty" wrote:
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(AL125, "p", 1))

adding range of numbers to if statement with three criteria
 

Works like a dream !

Thank you Frederik :-)
--
Mifty


"Frederik" wrote:

Hi Mifty

Hope this will do it:

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


"Mifty" schreef in bericht
...
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

adding range of numbers to if statement with three criteria
 

Brilliant :-) Thank you

--
Mifty


" wrote:

"Mifty" wrote:
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(AL125, "p", 1))