I have a formula that works fine now, but I want to add an additional condition.
The existing formula (below) resides in cell P2. It looks to see if cell E2 is blank. If E2 is blank then P2 is blank, if E2 is not blank, then P2 is populated with the result of N2-M2. Note, the values in N2 and M2 are dates using the format of 1/1/2014.
=IF(E2="","",N2-M2)
I want add another condition to this formula. Here is the overall logic I need.
If E2 is blank, then return blank
If E2 is not blank and J2 is blank, then perform N2-M2
If E2 is not blank and J2 is not blank, then perform M2-J2 (note that J2 is also a date in the format of 1/1/2014)
The existing formula (below) resides in cell P2. It looks to see if cell E2 is blank. If E2 is blank then P2 is blank, if E2 is not blank, then P2 is populated with the result of N2-M2. Note, the values in N2 and M2 are dates using the format of 1/1/2014.
=IF(E2="","",N2-M2)
I want add another condition to this formula. Here is the overall logic I need.
If E2 is blank, then return blank
If E2 is not blank and J2 is blank, then perform N2-M2
If E2 is not blank and J2 is not blank, then perform M2-J2 (note that J2 is also a date in the format of 1/1/2014)