|
help with a formula
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 |
help with a formula
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 |
| All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com