Possible in excel question

[mr. j]

Looking to see if this is possible in excel. It would be great if anyone could lead me in the right direction.

A1 there is a number
B2 Were text would go
C1 there is a number

If A1 is greater than C1 B2 says "Winner"
If A1 is less than C1 B2 says "Loser"
If A1 is equal to C1 B2 says "Draw"

Thanks

 

[SanjayGMusafir]

In B2 use -

=Ifs(A1>C1,"Winner",A1<C1'"Loser",True,"Draw")

 

[duggie33]

Hi mr. j,

=IFS(A1>A3,"Winner",A1<A3,"Loser",TRUE,"Draw")

Hope that helps,

Doug

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

how about

=choose(sign(a1-c1)+2,"Loser","Draw","Winner")

 

[mr. j]

Thanks all!

Fluff just went and added my version which is 365, Thanks.

 

[Fluff]

Thanks for that.
All options should work for you in 365.

 

[mr. j]

If I may ask one more thing on the =choose(sign(a1-c1)+2,"Loser","Draw","Winner") if I wanted to add say "**" for zero how would I add that to the formula?

 

[Fluff]

Not sure what you mean, can you post some sample data along with the expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[mr. j]

I am sorry, I didn't explain myself very well. If there is no data in a1 or c1 it says draw can I add to the formula so when there is no data in those two cells it would come up blank or with **?

 

[Fluff]

Ok, how about

=IF(OR(A1="",C1=""),"",CHOOSE(SIGN(A1-C1)+2,"Loser","Draw","Winner"))