Homework SourseEmployees Tab Plans Tab On Employees Tab use a formula which
Employees Tab
Plans Tab
| On [Employees] Tab, use a formula (which references [Plans] tab) to fill [Was Plan Effective Before Eligible?] for all records. You can easily see the answers on the plans tab, I just need the formula for it. Thank you. |
Solution
I am guessing that you are using Micrsoft Excel and the first column is for first name and so on. If this is not the case please comment.
=(IF(EXACT(H2,\"#NA\"),\"#NA\",(IF(C2<G2,\"yes\",\"no\"))))
The above function is for 2nd row.
![Employees Tab Plans Tab On [Employees] Tab, use a formula (which references [Plans] tab) to fill [Was Plan Effective Before Eligible?] for all records. You can](/WebImages/37/employees-tab-plans-tab-on-employees-tab-use-a-formula-which-1112765-1761590401-0.webp "Employees Tab Plans Tab On [Employees] Tab, use a formula (which references [Plans] tab) to fill [Was Plan Effective Before Eligible?] for all records. You can")
