Mar 15 2022 02:08 AM
Hey!
I need some help on a task in excel. Ive simulated a card game and cannot find out a way to use the IFS function.
Ive got four values (e.g. 1-2-2-2, 3-7-1-3, 9-9-9-5). I need to use the IFS forumla so that it returns if the 1st values=2nd value=3rd value or 1st values=2nd value=4th value or 1st value=3rd value=4th value or 2nd value=3rd value=4th value.
I use the formula =IFS(A2=B2=C2,"1") but it doesn't work.
Thanks!
Mar 15 2022 02:29 AM
SolutionMar 15 2022 02:33 AM
Mar 16 2022 11:24 AM
Mar 15 2022 02:29 AM
Solution