| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF isnt working right..Why?
Figured it out
thx "Curtis" wrote: =IF($C$5=1,-SUMPRODUCT(('[YTDTB ACTUAL ''09-10.xls]YTDTB99'!$A$3:$A$277=$B69)*('[YTDTB ACTUAL ''09-10.xls]YTDTB99'!$D$1:$CI$1=E$7)*('[YTDTB ACTUAL ''09-10.xls]YTDTB99'!$D$3:$CI$277)),0),IF($C$5=2,-SUMPRODUCT(('[YTDTB ACTUAL ''09-10.xls]YTDTB00'!$A$3:$A$277=$B69)*('[YTDTB ACTUAL ''09-10.xls]YTDTB00'!$D$1:$CI$1=E$7)*('[YTDTB ACTUAL ''09-10.xls]YTDTB00'!$D$3:$CI$277)),0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting isnt working right | Excel Discussion (Misc queries) | |||
| data subtotalling isnt working properly on my spreadsheet | Excel Worksheet Functions | |||
| autofilter isnt working | Excel Discussion (Misc queries) | |||
| Function isnt working, just displays the formula in cell?eg A2+B2 | Excel Discussion (Misc queries) | |||
| AutoFill isnt working? | Excel Discussion (Misc queries) | |||
Threaded Mode
