I know this question has been already asked a few times, but every statement that I try I end up with error messages.
I need a simple excel if statement where I can try out 3 possibilities:
I need to check 3 date columns, A1, B1 and C1. If all 3 are fullfilled, I need to subtract either C1 or B1 by A1. If B1 is empty, then I need to subtract C1 by A1. If C1 is empty, then I need to subtract B1 by A1. By all other results I need 0 to be returned.
Can anyone help me with that? I'm using excel 2016.
I tried the following statement: =IF(B2<>"";B2;C2)-A2
But it doesn't really cover all cases.
See Question&Answers more detail:os