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
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
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.