functions

[Guest]

this is the question from my workbook. Complete the worksheet by
calculating the matching retirement dollar amount for each faculty member.
Note not all faculty members participate in the plan. For any faculty
members participating in the retirement plan, the institution will contribute
(match) 3% of the faculty member
's salary, placing the contribution in the retirement fund. If the faculty
member is not participating, enter a zero in the appropriate cells. I have
to use the IF function and absolute addressing for the institutional match.
I need help with this function please.

 

[Guest]

I think we need more information. How are you determining if they are in the
plan? if you have a column that says like Y for active in the plan you could
use in an empty col.
=IF(A1="Y",B1*.03,0)

B1 being the individual's salary amount.