If Then with Multiple Ifs
I have two columns that I need to check if "true" before returning the text in the 3rd column. I am trying to create a formula that returns the Awarded Contractor's name in each City, i.e. Contractor Y for Boise and Contractor A for Chicago. I have tried a number of different IF, IFS, IF(AND) statements and can't figure it out. Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!