IF functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to calculating the matchin retirement dollar amount for faculty
members. the question wants to know for any faculty member who is
participating in the retirement plan the institution will contribute 3% of
the faculty member's salary. I have to use the IF function. I need help on
this please. pebbles2005
 
I should imagine something like this..........

A1=NAME
B1=SALARY
C1=PARTICIPATE?
D1=3% of Salary

In D2 put this formula and copy down as far as you have names in column A

=IF(AND(B2>0,C2="YES"),B2*.03,"")

Which says, if the salary cell in row 2 is greater than 0 and the
participate cell reads YES, then result is 3% of salary, otherwise the 3% of
Salary cells stays blank......

Then when you have Name, Salary, Yes/No in a row, the formula will calculate
the result

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top