| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem with excel formula
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula problem | Excel Discussion (Misc queries) | |||
| Excel Formula Problem | Excel Discussion (Misc queries) | |||
| Problem with formula in Excel | Excel Worksheet Functions | |||
| EXCEL FORMULA PROBLEM | Excel Discussion (Misc queries) | |||
Linear Mode
