Hiii,
I have attached a sheet inorder to understand better.
in the column ahead, i need a formula that can compare the km covered by car a and car b and decide which car is ahead?
as i come down the array it should sum the previous km covered and then compare.
Many thanks
One way, formula in row 2 and copied down
=IF(SUM(B$2:B2)=SUM(C$2:C2),"Tie","Car " & IF(SUM(B$2:B2)=MAX(SUM(B$2:B2),SUM(C$2:C2)),"a","b"))
Or this:
Formula:
Please Login or Register to view this content.
I think that E4 should return "tie"
Never use Merged Cells in Excel
Thanks a lot
=INDEX({"car b","tie","car a"},MATCH(SIGN(SUM(B$2:B2)-SUM(C$2:C2)),{-1,0,1}))
copy down
Ghozi, you don't need MATCH function...
It's enough to add +2 on SIGN resultFormula:Please Login or Register to view this content.
Since SIGN can return -1, 0 or 1 by adding +2 you will have 1,2,3 that you can use in your INDEX function.
Compare to mine solution above.
thank's a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks