Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Football score
=if(B4+B5;equal and greater0;2;0)
It's a football diagram So if the score is equal then show 2 point. But the problem is that when i havent inserted any score yet 0 and 0 is also equal and it prints 2 point.. So it got to be equal and larger than 1 then print 2 or else 0 Any tips on how to fix? |
#2
|
|||
|
|||
Quote:
That is if I understood your question.
__________________
Asobi Wa Owari Da |
#3
|
|||
|
|||
The problem is when i havent filled in the result yet, so when its empty its also the same and it print 2.
It got to be something like =IF(B4=B5and1;2,0) ? Now i got =IF(B3C3; "3"; IF(B3<C3; "0"; IF(B3=C3; "2"))) but it need the last if to be bigger than one or else its 0 |
#4
|
|||
|
|||
=IF(AND(B4=0,B5=0),0,IF(B4=B5,2,0))
__________________
Asobi Wa Owari Da |
#5
|
|||
|
|||
I dont get i to work
=IF(B3C3; "3"; IF(B3<C3; "0";IF(AND(B4=0,C4=0),0,IF(B4=B5,2,0)))) |
#6
|
|||
|
|||
Could you post a sample of the file you're working on? Even a screenshot would do.
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
Fantasy Football | Excel Discussion (Misc queries) | |||
Football pool | Excel Discussion (Misc queries) | |||
Football Coach needs help | Excel Discussion (Misc queries) | |||
Football Scores | Excel Discussion (Misc queries) |