If Function Help Please !!!

[Josie]

Hi All,


Trying to set up another If condition:


If Column E2 = hourly then multiple column F2*52/12


If Column E2 = salary then multiple column F2* 26 / 12


This is what I have and the 2nd part isn't calculating correcatly.


=IF(E2="hourly",F2*52/12)*(OR(E2="salary",F2*26/12))

 

[niting]

if Col E contains only hourly and salary, then the following should be fine-:


=if(e2="hourly",f2*52/12,f2*26/12)


Nitin

 

[Luke M]

=IF(E2="Hourly",52,26)*F2/12

 

[charlesalvear]

If you only have Hourly and Salary as values in Column E, then Niting's forumla should work for you. But if you have other pay types (like Modified Salary, say for someone who does not work 40 hours a week). Then you'll need to keep nesting the IF stmt:


=if(e2="hourly",f2*52/12,if(e2="salary",f2*26/12,if(e2="mod sal",e2*48/12,<more ifs etc&#62))