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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Cannot access to Office Insider 0
Adding recognised Zeros 5
Display weeks from a Milestone 0
#DIV error 2
Use TODAY() function as the criteria in a SUMIF formula 1
Excel - Wich Function should I use? 1
Count Number of Unique Cells That Don't Have Certain Characters 0

Top