Hi guys,
Using google sheets. But have a #VALUE error message (which I know why) but can someone help edit my formula to say instead of #VALUE return 0?
=IF(--(LEFT(F5,1))=--(RIGHT(F5,1)),"D",IF(AND(MATCH("Man Utd",E5:G5,0)=1,--(LEFT(F5,1))>--(RIGHT(F5,1))),"W",IF(AND(MATCH("Man Utd",E5:G5,0)=3,--(RIGHT(F5,1))>--(LEFT(F5,1))),"W","L")))
Thank you!
R.
Thanks,
R.
No idea if it works on Gogglesheets, but try
=IFERROR(IF(--(LEFT(F5,1))=--(RIGHT(F5,1)),"D",IF(AND(MATCH("Man Utd",E5:G5,0)=1,--(LEFT(F5,1))>--(RIGHT(F5,1))),"W",IF(AND(MATCH("Man Utd",E5:G5,0)=3,--(RIGHT(F5,1))>--(LEFT(F5,1))),"W","L"))),0)
bingo! thank you!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks