make:IF statement

I need to make an IF statement in cell G3.

I need to calculate regular pay. There are two different types. There are the Hourly workers, which are noted with the "H" in column D and there is "S" which is for the salary people. We ofcourse dont need to calculate the regular pay for the salary employees. So they would be the last part of the IF statement: "value if false".

I am stuck on making the IF statement though. How do i have it check Column D to see if the employee is an "H" or an "S". And if they are an H have it multiply column E "regular hours" by column F "pay rate" and then ofcourse "If false"..being that they are a salary employee then have it just put in the contents of column F since that is their fixed pay.

here is a pic of my sheet.

\1

Try

=IF(D3="H",E3*F3,F3)

Originally Posted by Cutter

Try

=IF(D3="H",E3*F3,F3)

ahhh thanks. the formula i originally created was just like that but I didnt think about putting the D3="H" i just idiotically put "H" lol. thanks

So close - don't forget to mark your thread as SOLVED

See FAQ button at top of page