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