When you the formula returns a "" and you add 1, it returns an error as "" is text
Try

For reasons unknown cell A4 is not empty but it contains a space " " which again returns an error as ""is not the same as " " ( a cell with a space is not empty)

I suppose this is a mistake??

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post