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(C7G7,'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

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(C7G7,'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