|
Re: Two quick questions
"timdee" wrote:
> .. Secondly, if there is a formula in a cell but no data for it to use it
> displays ####. Is it possible to stop this until data is entered?
Try something along these lines:
If C1 contains the formula, say: =A1/B1
try instead in C1: =IF(OR(A1="",B1=""),"",A1/B1)
The simple error trap: =IF(OR(A1="",B1=""),"", ... )
will help ensure that C1 returns a blank: "" instead of computing A1/B1
"prematurely", until values are entered in both A1 and B1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
|