Thread: problem with excel formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default problem with excel 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"L. Wilson" wrote:
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.
Reply With QuoteReply With Quote