Forum Discussion
Solved
Excel IF formula help
Hello everyone, I am attempting to set up an IF formula for multiple codes of date. I am trying to set up the formula where is Column E has the "GA" code- Column F will populate with "REG". I ne...
=IF(E2="BEREAVEMENT HQ","BRV",IF(E2="HOL HQ","HOL",IF(E2="PTO HQ","PTO",IF(E2="JD HQ","JD",IF(E2="ROUND","",IF(E2="GA","REG",""))))))You can try a nested IF formula. I assume that there are exact values (e.g. BEREAVEMENT HQ and HOL HQ) in column E as shown in your screenshot.
=IF(E2="BEREAVEMENT HQ","BRV",IF(E2="HOL HQ","HOL",IF(E2="PTO HQ","PTO",IF(E2="JD HQ","JD",IF(E2="ROUND","",IF(E2="GA","REG",""))))))You can try a nested IF formula. I assume that there are exact values (e.g. BEREAVEMENT HQ and HOL HQ) in column E as shown in your screenshot.
Thank you SO SO MUCH. I entered the formula you provided and all codes worked.
I was also able to add the GA code based off the formula you provided. Thank you so so much for all your help!
I was also able to add the GA code based off the formula you provided. Thank you so so much for all your help!