I have 3 columns...
"CEO" + "President" + "Vice President"
The 3 columns are using Choice field YES or NO (I tried and could also use drop down column Yes/No). The CEO or President or VP will go to their respective column, and select Yes or No when they want to approve a document.
I have a fourth is a calculated column which is Status, and I would like when the 3 columns all chose Yes, that the 4th column "Status"
Right now, I used the following formula
=IF([Yes/No - D]="Yes","Approve","Pending")
This allows me to choose Yes or No and it change to Pending or Approved. It is working. I would like to see if any one can help with 2 things, I have checked dozens of sites and forums.
I'd like to first see if it's possible to add a 3rd category such as Not Approved, so the column will switch to Not Approved if they click No, Approved it they click Yes, and Nothing will have Pending...
The second thing I would like is to have all 3 columns (CEO, P, VP) use the same formula but add them together, so only if all 3 columns are YES, then the calculated column I set up Status, will show Approved, otherwise, it will show pending, or if they all choose NO, it will show Not Approved.
I know this is possible, just having trouble combining multiple IF columns. I can clarify if needed