Forum Discussion
Solved
IFS Statement with 3 Categories
I have the following table I'm trying to run an IFS statement across, to pick up the relevant status code: Status Code List #1 List 2 1.2.3 1.2.3 0 0 1.3.4 1.3.4 0 0 1.6.7 1...
- grantwilliams275
Hi Kindly use the below formula.
=IFS(LEFT(IFNA(B2,2),1)="1",B2,LEFT(C2,2)="PE",C2,LEFT(D2,2)="PO",D2,TRUE,"TBD")
You are a genius; that works perfectly. Thank you! Tejas_shah