JimS
02-23-2009, 01:49 PM
I have the following formula, which works fine, but is it possible to modify it so that if the result of the formula is equal to 0 (zero) then enter a Blank in the cell?
=IF($B10="","",SUMPRODUCT((TEXT(WEEKDAY(Timecard!$A$4:$A$53),"ddd")=D$9)*(Timecard!$D$4:$D$53=$B10)*(Timecard!$C$4:$C$53)))
Because I'm using the first condition to determine if the formula should even be executed ($B10="",""), I'm not sure how to make a resulting 0 a Blank.
Thanks for any and all help...
Jim
=IF($B10="","",SUMPRODUCT((TEXT(WEEKDAY(Timecard!$A$4:$A$53),"ddd")=D$9)*(Timecard!$D$4:$D$53=$B10)*(Timecard!$C$4:$C$53)))
Because I'm using the first condition to determine if the formula should even be executed ($B10="",""), I'm not sure how to make a resulting 0 a Blank.
Thanks for any and all help...
Jim