LinkBack URL
About LinkBacks
saidul 
If A1< B1=sum go to C1 and D1 blank.
If A1 > B1=sum go to D1 and C1 blank.
If A1< B1=sum go to C1 and D1 blank.
If A1 > B1=sum go to D1 and C1 blank.
Hi,
I'm guessing somewhat here since your request is not very clear. A worked example workbook would have been quite helpful.
C1:
=IF(A1<B1,Sum(A10:A20),"")
D1
=IF(A1>B1,Sum(B10:B20),"")
change the sum ranges as necessary.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks