| 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 |
| 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 | |||
Threaded Mode
