Forum Discussion
leave cell blank until formula has all info to complete task, I should know this but, blonde showing
leave formula cell blank until formula has all info to complete task, I should know this but, blonde showing. =Sum(b4*c5)
Do you mean B4:C5? If yes, my sugeestion is below
=IF(COUNTBLANK(B4:C5)>0,"",SUM(B4:C5))
=IF(COUNTBLANK(B4:C5)>0,"",SUM(B4:C5))
I'm trying to avoid all the $0.00 on the page. To give you an idea as to what I'm trying to do
I want to multiply the info in b times c with answer on column d on line 4 now this might not happen again until line 15 where there is info in b and c cells. So I would copy and paste =sum(b*c) in column D now this would put $0.00 in all of column d. I would like to not see the $0.00 in all the unused lines in column d. It makes finding things easier.
I want to multiply the info in b times c with answer on column d on line 4 now this might not happen again until line 15 where there is info in b and c cells. So I would copy and paste =sum(b*c) in column D now this would put $0.00 in all of column d. I would like to not see the $0.00 in all the unused lines in column d. It makes finding things easier.
Allthingstiny Based on your description, this is probably what you need (note that you don't need SUM):
=IF(OR(B4="",C5=""),"",B4*C5)
Alternatively, you could just use =B4*B5 and suppress eventual zeroes with a custom format like General;General;
