Good morning,
I have the following simple formula that works out which is the greater amount, the first 9 cells or second 9 cells.
=IF(D5+F5+H5+J5+L5+N5+P5+R5+T5>V5+X5+Z5+AB5+AD5+AF5+AH5+AJ5+AL5,"F","B")
Unfortunately it returns "B" if the total are equal. What can I add to the formula to show if the totals are ever equal please? I'd probably have "E" as the result.
Many thanks.
Bookmarks