I was hoping to hear you mention that syntactical trick of invoking IFERROR(1/0) in the second half of a parent IFERROR() to coerce a true null in the output.
Excellent run down. I was being driven mad with a #NA (I think returned from a GoogleFinance(..."name") lookup. I couldn't reference it in any other column as the #NA got propagated. I think I set up another column and just did a =K21L21 in a formula (equality test) and then was able to test the results for subsequent cell IF processing.
This video is great and will be very useful. However, I have a question regarding the topic of the video, which is "Common Formula Errors in Google Sheets and How To Fix Them". I would like to know if there is a specific tab or sheet related to this topic that I can access. If so, could you please tell me its location?
I was hoping to hear you mention that syntactical trick of invoking IFERROR(1/0) in the second half of a parent IFERROR() to coerce a true null in the output.
Otherwise a great primer on errors!
@@helmanfrow thanks
Excellent run down. I was being driven mad with a #NA (I think returned from a GoogleFinance(..."name") lookup. I couldn't reference it in any other column as the #NA got propagated. I think I set up another column and just did a =K21L21 in a formula (equality test) and then was able to test the results for subsequent cell IF processing.
Thanks, Scott. Yes, the IF function with equality tests is another useful way to deal with errors 👍
There is also this Data Validation error
This video is great and will be very useful. However, I have a question regarding the topic of the video, which is "Common Formula Errors in Google Sheets and How To Fix Them". I would like to know if there is a specific tab or sheet related to this topic that I can access. If so, could you please tell me its location?
Thanks, Bradley. More info in the written post: www.benlcollins.com/spreadsheets/formula-parse-error/
Whn i try to make this formular =COUNTIF(F4:F500,">0") /COUNTA(F4:F500) It Says Error How do i fix that?
@Ben Collins
how to return cell address with XLOOKUP function of a last non-blank cell in google sheets?
Try wrapping it with the ArrayFormula designation and then it should work the same way, e.g. =ArrayFormula(XLOOKUP(TRUE,B5:B16"",B5:B16,,,-1))