Forum Discussion
Looking for a way for the IFS function to return a specific value based on several factors.
Hello! I know a fair bit about excel formulas but this one is stumping me. I'm looking for a formula that will return a specific value based on what data is found on my table. I think the formula tha...
If you have access to the LET function, you can cut some corners for the formula.
=LET(
result, TEXTJOIN(", ", , SORT(UNIQUE(TOCOL(C6:D9)))),
IF(
result = "Pass, Pending",
"Pass - Incomplete",
IF(
result = "Fail, Pending",
"Fail - Incomplete",
IF(XOR(result = {"Pass", "Fail", "Pending"}), result, "none")
)
)
)
the LET function is new to me so i'm definitely going to have to spend more time learning about it. the way your formula is set up is very clean and i don't quite understand how it works but it does just exactly what i'm looking for it to do. thank you for your help ! seeing a fully complete formula like this will help me better understand how to write it myself in the future