problem with excel formula

  • Thread starter Thread starter L. Wilson
  • Start date Start date
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.
 
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
 
Back
Top