help with a formula

[n1kk1]

Hello, I have the following formula that relates to another workshee
where I am asking excel to show '3' if both cells are the same
otherwise '0' and show '1' for whatever figure is highest, this al
works fine but when the cells are empty they are obviously showing '3
- how can I get it to show '0' when cells are blank..?

=IF(C7+G7='Winning Scores'!B5+'Winnin
Scores'!D5,"3","0")+IF(OR(AND(C7>G7,'Winning Scores'!B5>'Winnin
Scores'!D5),AND(AM!C7<AM!G7,'Winning Scores'!B5<'Winnin
Scores'!D5)),1,0)

Thanks for all the advice out there this site has been a huge help!

n

 

[Guest]

check the empty cell first.
=IF(OR((C7=""),(G7="")),0,"continue to put if forumula ")