Nothing in the cells but still getting values returned

Brown

Board Regular
Joined
Sep 14, 2009
Messages
224
Office Version
  1. 365
Can someone help me figure out why this is happening.
I have a formula to determine the winner of the game when I place scores in C3 and E3, but when there is nothing in those cells why am I getting a winner? This is throwing off columns H and I. Can this be fixed?
Thanks
Brown
1739746190647.png
 
It's returning D3 because C3 is not greater than E3. If you want it to be blank when no scores are entered then you need to include that as a condition.

=IF(OR(C3="",E3=""),"",IF(C3>E3,B3,D3))
 
Upvote 0
Another approach,
Book1
ABCDEF
1FridayField 13Winner
24:00 PMCampbellN. Foryth 
36:30 PMMarietta10Norcross10Draw
4Saturday 
510:00 AMNorcross8Campbell6Norcross
612:30 PMNorcross2N. Foryth4N. Foryth
73:00 PMMarietta0Campbell0Draw
85:30 PMMarietta10N. ForythMarietta
Sheet1
Cell Formulas
RangeFormula
F2:F8F2=IF(AND(C2="", E2=""), "", IF(C2=E2, "Draw", IF(C2>E2, B2, D2)))
 
Upvote 0
Solution
Thank you both! I know enough to get me in trouble, but not enough to get me out of trouble.
I sincerely appreciate your assistance.
Brown
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top