Formula edit
thank you
"Elkar" wrote:
Its the same one.
If [yourformula] is an error
then display nothing
else display [yourformula]
For example, lets say your formula is A1+B1, then it would look like this:
=IF(ISERROR(A1+B1),"",A1+B1)
HTH,
Elkar
"sunderland27" wrote:
what is the 2nd formula listed below?
"Elkar" wrote:
You could use something like this:
=IF(ISERROR(formula),"",formula)
This will evaluate your formula, then, if an error is returned, it displays
a blank, otherwise, the results of the formula are displayed.
HTH,
Elkar
"sunderland27" wrote:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
|