Greetings, Im having some trouble returning a value in my IFS statement and am hoping for some help.
I am trying to pull data from one column when a specific data set is present and in addition another column when an employee count is present - Here is what ive got and im getting "NA":
=IFS(A2="Random Text",IF(Master!C2="0-9",240))
Thanks in advance for your help here!
I am trying to pull data from one column when a specific data set is present and in addition another column when an employee count is present - Here is what ive got and im getting "NA":
=IFS(A2="Random Text",IF(Master!C2="0-9",240))
Thanks in advance for your help here!