| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the IF function to work on more than one criterion?
Hi!
I'm writing a formula but I can't get my head around it. The Formula below works: =IF(EG8<2,IF(C8=1,ED8*Fees!D8,IF(C8=2,ED8*Fees!D18 ,IF(C8=3,ED8*Fees!D28,0))),0) However I also need to add IF(EG82<3,IF(C8=1,ED8*Fees!D9,IF(C8=2,ED8*Fees!D1 9,IF(C8=3,ED8*Fees!D29,0)))) and IF(EG83<6,IF(C8=1,ED8*Fees!D10,IF(C8=2,ED8*Fees!D 20,IF(C8=3,ED8*Fees!D30,0)))) Am I asking too much or can it be done??? Thanks in advance for ANY kind of response! ---------- It's Thank You and Goodnight! :o) xx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DBSUM function but with function as criterion, not a range | Excel Worksheet Functions | |||
| SUMIF Criterion with NOT | Excel Worksheet Functions | |||
| Multiple Criterion in a SUMIF function | Excel Worksheet Functions | |||
| IF(<criterion across sheets,1,0)? | Excel Worksheet Functions | |||
| How do I put more than one criterion in a SUMIF function? | Excel Worksheet Functions | |||
Threaded Mode
