Forum Discussion
Solved
Excel IFS Function
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 fo...
- you need to use AND(), just like you would using nested IF()...
IFS(AND(A2=B2, B2=C2), "1", AND(B2=C2, C2=D2), "2", TRUE, "??NOT FOUND IN LIST")
re the TRUE entry, I always put a "catch-all" at the end of IFS so that anything unexpected doesn't return a # error but gives an indicator to describe the issue
Thank you so much you're literally a life saver!! I also need to do a straight e.g. (1-2-3-4) and don't know how to do that (Im not that good at excel). Any ideas?
Just include the extra entries in the 'AND() separated by commas. Take what is there before as an example and see if you can expand on it.