Hello,A9 is the sum from A1 to A7 and B9 is the sum from B1 to B7.I need formula in A8 & B8.If A9>B9, formula will show the difference in B8 andIf A9<B9, formula will show the difference in A8. Thank you.

Oliullah_Siddique In the attached file you will find the example with the formula

Forum Discussion

Brass Contributor

Aug 16, 2022

Solved

Hello,

A9 is the sum from A1 to A7 and B9 is the sum from B1 to B7.

I need formula in A8 & B8.

If A9>B9, formula will show the difference in B8 and

If A9<B9, formula will show the difference in A8.

Thank you.