I'm trying to calculate the score for a football championship, where victory is three points, zero points defeat and a draw 1 point. I have the following formula. = IF (OR (F31 = H31, 1), IF (H31> = F31, 1, 3)), I am not able, to return to zero when the team is in cell F31, the draw to win returns true. Someone can help me?
Thank you
Hi and welcome to the forum.
What numbers are in F31 and what in H31?
Do you mean something like this?
=IF(F31>H31,3,IF(F31=H31,1,0))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks