If there is no value in the first column N2 I need to calculate the value in M2, if there is no value there I need to calculate based on my L2. e.g.
Current formula:
=IF(N2="",M2-G2,IF(M2="",L2-G2,G2-G2))
Capture.GIF
If there is no value in the first column N2 I need to calculate the value in M2, if there is no value there I need to calculate based on my L2. e.g.
Current formula:
=IF(N2="",M2-G2,IF(M2="",L2-G2,G2-G2))
Capture.GIF
Hello Travis83. Welcome to the forum.
Try
A B C D E F 1 expected arrival Date 1 Date 3 Date 2 Deviation (Neg=early) 2 7/9/2019 7/1/2019 7/12/2019 11 In E2: =LOOKUP(1E+306,A2:D2)-INDEX(A2:D2,MATCH(1E+306,A2:D2,1)-1) 3 7/9/2019 7/1/2019 7/2/2019 7/2/2019 0 4 7/4/2019 6/20/2019 -14 5 7/4/2019 6/18/2019 6/26/2019 6/26/2019 0
Dave
Or, you could try it this way in E2:
=IF(D2="",IF(C2="",IF(B2="",A2-A2,B2-A2),C2-A2),D2-A2)
then copy down.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks