Forum Discussion
Solved
Excel Formula
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 A...
In A8:
=IF(A9>B9,A9-B9,"")
In B8:
=IF(B9>A,B9-A9,"")
Both cells will remain blank if A9=B9
Thank you very much.