Help Required: Conditional Formula with multiple AND/OR scenarios

Hi there,

Seeking help to complete a formula. In column A, I am looking to define which 'product' (Sports, Poker, Games, Casino) offers the greatest value.

This first image shows the result when there is a ZERO total in one cell. Any help getting the formula to return the greatest value 'product' in A2 would be appreciated. The formula I've used is 'good' for one.

With zero.png

As you can see with a value in cell C2, the formula works (but there will be ZERO totals in the spreadsheet to overcome!)

With value.png

Next step is going from IF E2>B2,C2,D2 THEN A2 = "CASINO" to IF E2>B2,C2,D2 THEN A2 = "CASINO" OR IF D2>B2,C2,E2 THEN A2 = "GAMES" OR IF C2>B2,D2,E2 THEN A2 = "POKER" OR IF B2>C2,D2,E2 THEN A2 = "SPORTS" (factoring the zero issue)

Would appreciate some help!

Thanks,

Tom

As it's your first post, you might not realise that many contributors are unable to view .PNG files on this Forum (incompatibility with some browsers), so it would be better to submit a sample Excel workbook. If you really must submit pictures, change the format to JPEG, or put them in a PDF file, although there's not a lot we can do with them.

Hope this helps.

Pete

Please post a sample file showing expected outcomes.

Thanks Mazzaropi - that worked perfectly.

And thanks everyone for the guidance. I will upload as instructed in future