I am trying to created a formula in my spreadsheet in which if a certain cell has the text value of "enrolled" then the spreadsheet reflects the difference of two cells. I entered this formula but it is incorrect.
=IF(B2="enrolled", R2-N2)
How do I fix this? I also want to add into the formula if the text value is "waived" or "terminated" then the value will be "N/A"