date range
Gerald wrote:
Dears,
when I pull a report on date range, if there is not info. between
these dates I get a error in a total field, which true b'c there is
not data processed within these dates
how do I get a rid of the message error and replace it with zero or a
text message
thanks and any help will be appreciated
Hi Gerald,
just incapsulate your formula into an IF function:
=IF(ISERROR(your_formula),"",your_formula)
with above formula you'll see blank cells replacing errors. If you want
replace errors with zeros, use this way:
=IF(ISERROR(your_formula),0,your_formula)
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|