LinkBack URL
About LinkBacks
If A1 is blank, B1+1.
B1 may be an error. If B1+1 is error, C1+1
C1 may be an error. If C1+1 is error, D1+1
This is what I have come up with, but it doesn't work: =IF(ISBLANK(A1),B1+1,IFERROR(B1+1,C1+1),IFERROR(C1+1,D1+1))
Thank you in advance!
If A1 is blank, B1+1.
B1 may be an error. If B1+1 is error, C1+1
C1 may be an error. If C1+1 is error, D1+1
This is what I have come up with, but it doesn't work: =IF(ISBLANK(A1),B1+1,IFERROR(B1+1,C1+1),IFERROR(C1+1,D1+1))
Thank you in advance!
Hi,
=IF(ISBLANK(A1),IFERROR(B1+1,IFERROR(C1+1,D1+1)))
Regards
What if A1 is not blank?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
"What if A1 is not blank?"
Good point!
If A1 is not blank, return A1. That part of the formula is working fine, it's the other part I am having trouble with.
Hi,
You didn't say what the default position is if A1 is NOT blank. So I have made an assumption.
Formula:
Please Login or Register to view this content.
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)
Posting Permissions
Register To Reply
Bookmarks