In a large spreadsheet, one of my formulas is this:
It works 99% of the time, but occasionally the numbers in column G return a NUM error. The formula for column G is much longer than the formula above, so I thought it would be easier to use for my solution.
Please Login or Register to view this content.
How do I get a 0 or a "" in column H if column G is #NUM! ?
Thanks!
Use =IFERROR(yourFormula,"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
YOU could just wrap the whole formula in an =IFERROR() function
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
One way...
Replace this:
=IF(G318<>"",
With this:
=IF(ISNUMBER(G318),
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks everyone! I appreciate your smarts!
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks