Y
yesterdaytoday11
columns B and C are the trial balance numbers (debits and credits)(sometimes
blank) columns D and E are adjusting entries (always positive)(debits,
credits)
columns F and G should return correct value and should hold the formula's.
I have been trying with
=IF(ISBLANK(B9:E9),"",IF(AND(B9>=C9,D9>=E9),B9+D9,IF(AND(B9>C9,E9>D9),B9-E9,IF(AND(C9>B9,D9>C9),D9-C9,""))))
but maybe it could be shorter?
blank) columns D and E are adjusting entries (always positive)(debits,
credits)
columns F and G should return correct value and should hold the formula's.
I have been trying with
=IF(ISBLANK(B9:E9),"",IF(AND(B9>=C9,D9>=E9),B9+D9,IF(AND(B9>C9,E9>D9),B9-E9,IF(AND(C9>B9,D9>C9),D9-C9,""))))
but maybe it could be shorter?