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)
5 Replies
If 'X' and 'Y' were defined names given to the two columns, the specific test for presence of numbers is the function ISNUMBER.
= IF(ISNUMBER(X)*ISNUMBER(Y), X*Y, "")With 365 insider, I can play all sorts of games to upset a traditional spreadsheet author. For example, given 'data' that includes both 'X' and 'Y',
= BYROW(Data, LAMBDA(d, IF(AND(ISNUMBER(d)),PRODUCT(d),"") ))will return the entire column of results.
"Blond showing" I hope this does not make you grab the peroxide bottle!
- Thank you Peter, that is what I was looking for.
- Do you mean B4:C5? If yes, my sugeestion is below
=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.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;
