date range
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 |
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 |
date range
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 |
All times are GMT +1. The time now is 01:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com