Hi,
You didn't say what the default position is if A1 is NOT blank. So I have made an assumption.
Formula:
=IF(ISBLANK(A1),IF(ISERROR(B1),IF(ISERROR(C1),D1+1,C1+1),B1+1),"A1 Not blank")
Hi,
You didn't say what the default position is if A1 is NOT blank. So I have made an assumption.
Formula:
=IF(ISBLANK(A1),IF(ISERROR(B1),IF(ISERROR(C1),D1+1,C1+1),B1+1),"A1 Not blank")
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks