i need help please.....

[mattybayston]

Hi im currently trying to create a soccer table in excel that automatically updates when i put the scores in.

I seem to have cracked everything but the amount of games played in the table.

Basically im using the IF function to determine points from a certain result. However if both cells are blank (i.e game not played yet) the IF function is stil returning with "1" as if the game was a draw as both cell are equal.

is there any way to have the cell remain empty untill actual results are inputted into the cells where the rule applies?

Not sure if this makes much sense without seeing the workbook but there does not seem to be a way i can attach it

Any advice or help would be extreamly appreciated,

Cheers

Matty

 

[mattybayston]

sorry forgot to add, current formula i am using is;

=IF($B$11>$D$11,3,IF($B$11=$D$11,1,0))

this gives me 3 points if the score is greater, 1 if a draw, 0 if less than.

the probem is when the cells are empty it is still coming back with 1, because they are equal even though there is noting in them

Cheers

 

[AlphaFrog]

Try something like this...

=[COLOR="Red"]IF($B$11="","",[/COLOR]IF($B$11>$D$11,3,IF($B$11=$D$11,1,0))[COLOR="Red"])[/COLOR]

 

[mattybayston]

outstanding!!!! Thank you so much!