| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a range of numbers associated with various dates | Excel Discussion (Misc queries) | |||
| adding numbers in a specific range of values | Excel Discussion (Misc queries) | |||
| Single statement database/range processing with criteria | Excel Worksheet Functions | |||
| IF than statement in a range of numbers? please help? | Excel Discussion (Misc queries) | |||
| How do I use a range of numbers in an if statement? | Excel Worksheet Functions | |||
Linear Mode
