Hello Everyone (first post),
Long time Excel user getting more advanced with cell logic formulas, need some help please. I'm trying to apply a logic to column 3 cell, which is dependent on logic in the column 2 cell, which will only apply if the cell in column 1 is empty, otherwise, it will populate the info from the cell in column 1 directly to the cell in column 3. My current formula looks like this:
Cell A3=IF(a1<>"",a1,(=if(a2="no","Not Required", (if(a2="yes", "Required")))))
Bookmarks