Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if formula results in False - can you help?
Here is my formula - it ends up with FALSE - I must have a ) in the wrong
place can anyone help? Essentially I don't want to end up with a ##### (negative number result) so I came up with this formula. If there is a way to make the ##### actually look like a proper negative number or blank that would be even better. Thanks =IF(IF(AND(BY200,BY20-CA200),SUMPRODUCT(('Incidents 2010'!$C$20:$C$6998="good")*('Incidents 2010'!$W$20:$W$6998="TSP_CIM_USAWM")*('Incidents 2010'!$N$20:$N$6998=3)*('Incidents 2010'!$O$20:$O$6998=DATE(2010,1,1))*('Incidents 2010'!$O$20:$O$6998<DATE(2010,2,1)),'Incidents 2010'!$I$20:$I$6998)/(BY20-CA20))0,IF(AND(BY200,BY20-CA200),SUMPRODUCT(('Incidents 2010'!$C$20:$C$6998="good")*('Incidents 2010'!$W$20:$W$6998="TSP_CIM_USAWM")*('Incidents 2010'!$N$20:$N$6998=3)*('Incidents 2010'!$O$20:$O$6998=DATE(2010,1,1))*('Incidents 2010'!$O$20:$O$6998<DATE(2010,2,1)),'Incidents 2010'!$I$20:$I$6998)/(BY20-CA20),"")) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if formula results in False - can you help?
Remove the double IF at the start.
Regards, Fred "catts22" wrote in message ... Here is my formula - it ends up with FALSE - I must have a ) in the wrong place can anyone help? Essentially I don't want to end up with a ##### (negative number result) so I came up with this formula. If there is a way to make the ##### actually look like a proper negative number or blank that would be even better. Thanks =IF(IF(AND(BY200,BY20-CA200),SUMPRODUCT(('Incidents 2010'!$C$20:$C$6998="good")*('Incidents 2010'!$W$20:$W$6998="TSP_CIM_USAWM")*('Incidents 2010'!$N$20:$N$6998=3)*('Incidents 2010'!$O$20:$O$6998=DATE(2010,1,1))*('Incidents 2010'!$O$20:$O$6998<DATE(2010,2,1)),'Incidents 2010'!$I$20:$I$6998)/(BY20-CA20))0,IF(AND(BY200,BY20-CA200),SUMPRODUCT(('Incidents 2010'!$C$20:$C$6998="good")*('Incidents 2010'!$W$20:$W$6998="TSP_CIM_USAWM")*('Incidents 2010'!$N$20:$N$6998=3)*('Incidents 2010'!$O$20:$O$6998=DATE(2010,1,1))*('Incidents 2010'!$O$20:$O$6998<DATE(2010,2,1)),'Incidents 2010'!$I$20:$I$6998)/(BY20-CA20),"")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula shows false | Excel Worksheet Functions | |||
False if statement in series results in zero value in chart | Charts and Charting in Excel | |||
Indexing/Matching True/False results | Excel Worksheet Functions | |||
Convert TRUE/FALSE results to a number | Excel Worksheet Functions | |||
Adding True False Results | Excel Worksheet Functions |