problem with excel formula

L

L. Wilson

When using a formula how do i get the box with the formula to show a zero
until the numbers are entered in the other boxes of the formula.
 
M

Max

One way is to bolt on a COUNT check on the precedents
Eg in D1: =IF(COUNT(A1:C1)<3,0,A1*B1/C1)
D1 will return 0 until A1:C1 are filled with numbers
 
Top