help with a formula

[n1kk1]

Hello, I have the following formula that relates to another worksheet 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 all 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+'Winning Scores'!D5,"3","0")+IF(OR(AND(C7>G7,'Winning Scores'!B5>'Winning Scores'!D5),AND(AM!C7<AM!G7,'Winning Scores'!B5<'Winning Scores'!D5)),1,0)

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

nx

[Anna]

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



"n1kk1" wrote:

>
> Hello, I have the following formula that relates to another worksheet
> 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 all
> 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+'Winning
> Scores'!D5,"3","0")+IF(OR(AND(C7>G7,'Winning Scores'!B5>'Winning
> Scores'!D5),AND(AM!C7<AM!G7,'Winning Scores'!B5<'Winning
> Scores'!D5)),1,0)
>
> Thanks for all the advice out there this site has been a huge help!
>
> nx
>
>
> --
> n1kk1
> ------------------------------------------------------------------------
> n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173
> View this thread: http://www.excelforum.com/showthread...hreadid=550311
>
>