Is there a simple way I can remove this from my formulas?
e.g. A1*B1 =
where B1 will either be a number or the following words; exc, inc, by others, more info.
Is there a simple way I can remove this from my formulas?
e.g. A1*B1 =
where B1 will either be a number or the following words; exc, inc, by others, more info.
Hi gjjh25
Wrap the formula in the IFERROR.
=IFERROR(A1*B1,"") Or what ever you want to return if it is a error.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Kevin
Thank you very much that has worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks