I'm trying to build a formula for the following:
If D2 = any part of H2, ORD
else if D2=N2, WBS
else Not Ready
Here's what I have, that Excel is not happy with. Where am I going wrong?
Thanks!
If D2 = any part of H2, ORD
else if D2=N2, WBS
else Not Ready
Here's what I have, that Excel is not happy with. Where am I going wrong?
Excel Formula:
=IF(D2="*"&H2&"*","ORD",IF(D2=N2,"WBS","Not Ready")"Not Ready")
Thanks!