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

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

thanks (y)

"Franz Verga" wrote:

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