| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nesting issue in functions
How can I get around the 7 nesting limitations. This is my formula
=IF(AND($A$10="quanta utility services, LLC.",$G$27<499),0.33,IF(AND($A$10="quanta utility services, LLC.",$G$27=499,$G$27<=999),0.75,IF(AND($A$10="qu anta utility services, LLC.",$G$27=1000,$G$27<=1999),0.99,IF(AND($A$10=" quanta utility services, LLC.",$G$27=2000,$G$27<=4999),9.99,IF(AND($A$10=" quanta utility services, LLC.",$G$27=5000),19.99))))) This works but I would like to have multiple values for A10. I tried to copy it and change the value of a10 each time but I can only add 2 more. Example: =IF(AND($A$10="quanta utility services, LLC.",$G$27<499),0.33,IF(AND($A$10="quanta utility services, LLC.",$G$27=499,$G$27<=999),0.75,IF(AND($A$10="qu anta utility services, LLC.",$G$27=1000,$G$27<=1999),0.99,IF(AND($A$10=" quanta utility services, LLC.",$G$27=2000,$G$27<=4999),9.99,IF(AND($A$10=" quanta utility services, LLC.",$G$27=5000),19.99)))))=IF(AND($A$10="quanta utility services, LLC.",$G$27<499),0.33,IF(AND($A$10="Pumpco.",$G$27 =499,$G$27<=999),0.75,IF(AND($A$10="Pumpco.",$G$2 7=1000,$G$27<=1999),0.99,IF(AND($A$10="Pumpco.",$ G$27=2000,$G$27<=4999),9.99,IF(AND($A$10="Pumpco. ",$G$27=5000),19.99))))) This returns a value of false. Any help would be appreciated Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do u emulate nesting seven IF functions in a cell? | Excel Worksheet Functions | |||
| Nesting VLOOKUP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
| What is the syntax for nesting functions such as IF AND? | Excel Worksheet Functions | |||
| nesting 18 x functions | Excel Worksheet Functions | |||
Threaded Mode
