Forum Discussion
how to substitute or mask "#VALUE!" on the fly without creating a intermediate cell/formula
I have the following formula: =IF(SEARCH("XYZ", Product),Product, 0) where: Product is a named area in a spreadsheet. From time to time the pattern "XYZ" is not found (and it should be so) and th...
Thx
I used
=IF(IFERROR(SEARCH("XYZ", Product), 0),Product,0)
and now it works (again I wanted the 'answer' w/o an in-between calculation.
Your formula gives 0 or 1 and not the name of the product or 0
Thanks again
I used
=IF(IFERROR(SEARCH("XYZ", Product), 0),Product,0)
and now it works (again I wanted the 'answer' w/o an in-between calculation.
Your formula gives 0 or 1 and not the name of the product or 0
Thanks again
