I have a sheet that calculates bowling scores over 8 games. When the games start all the scores are zero by default. My If statement calculates a two cells with zero as true and awards 1 point as a draw. =IF(I6>0,2,IF(I6=0,1,IF(I6<0,0,)))
i want the if statement in E5 to disregard awarding 1 point as a draw if both A5 and B5 are 0. or blank. Show zero is turned on, as some games may have a result such as 0 - 15
Maybe one way:
=IF(OR(AND(A5=0,B5=0),AND(A5="",B5="")),0,IF(C5>0,2,IF(C5=0,1,IF(C5<0,0,))))
Regards, TMS
Or, a bit shorter:
=IF(SUM(A5,B5)=0,0,IF(C5>0,2,IF(C5=0,1,IF(C5<0,0,))))
Regards, TMS
This should work
=IF(C5>0,2,(C5=0)*(A5>0))
Audere est facere
Thanks for the help, but i think i have made a mistake in my explanation.
Cell f5, = IF(A5>B5,"W",IF(A5<B5,"L", IF(A5=B5,"D")))
i require this to ignore the (A5=B5) if Cells A5 and A6 are both zero
=IF(A5>B5,"W",IF(A5<B5,"L", IF(SUM(A5+B5)=0,"","D")))
Regards, TMS
Hi
In F5, try this.
=IF(A5>B5;"W";IF(A5<B5;"L";IF(AND(A5=0;A6=0);"";IF(A5=B5;"D"))))
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
if Cells A5 and A6 are both zero
Can I ask why?
Regards
in a game, the score could be like this 10-0
To show the zero in the for or against cells i had to activate the show zero in cells option. This means by default the Calculation i used read the blank cells as a zero
i have put in your suggestions an d it is working ok now.
Many Thanks
Thanks this works as well,
Originally Posted by Fotis1991
You are welcome!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
No, I'm asking why you said:
A6 is in the row below A5 so why would you be checking a score on one row against the score on the next row.if Cells A5 and A6 are both zero
Fotis has rightly provided a solution that matches your question/request and which you have said.Thanks this works as well
I'm just trying to understand why you want this, what it does, and how you have tested it. Do all the rows have zeroes in them at the moment? In which case, it is quite likely that it does work but for the wrong reason.
Anyway, if you are happy with the solutions that you have been given, that's fine.
Thanks for the rep, regards, TMS
It should have been A5 - A 6 my typo.
But its all working, i modified the cell indicator
Regards
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks