Help with IF formula for multiple criteria and outcomes

[TheRumBaron]

Hi All,

I am trying to create a sports betting slip, similar to a normal coupon from a book makers, which I can update during the match, and it will show the overall status for the bet...see pics below for better explanation :D

In the 'BET RESULT" I have used the following formula -

=IF(COUNTIFS(D4:D5,"<>"&"",D4:D5,"<>"&"WON",D4:D5,"<>"&"VOID"),"LOST","WON")

The only issue I have, is that when a Result Cell is blank, the bet result states 'WON' (example Coupon 3), I would like to make it, so that if a cell (in the result column) is Blank, then it will automatically change the bet result field to 'IN PLAY'

I am awful at explaining, but hopefully this provides enough info!

Any help would be massively appreciated!

 

[ExceLoki]

try something like this:

=IF(OR(D4="",D5=""),"In Play",IF(COUNTIFS(D4:D5,"<>"&"",D4:D5,"<>"&"WON",D4:D5,"<>"&"VOID"),"LOST","WON"))

 

[TheRumBaron]

try something like this:

=IF(OR(D4="",D5=""),"In Play",IF(COUNTIFS(D4:D5,"<>"&"",D4:D5,"<>"&"WON",D4:D5,"<>"&"VOID"),"LOST","WON"))

YES Thank you so much!!!