Dear Team,
Can you please help me with the formula ?
A B C D E G H Final Output Condition
7 10 15 14 15 8
9 10 12 15 6 if col A is blank, then Col E - Col B
8 11 15 7 if col B is blank, then Col E - Col C
10 15 5 if col C is blank, then Col E - Col D
5 15 10 Since col B is non blank, then Col E - Col B
Bookmarks