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))
This was great help, however, I made an error when stating my equasion above, it should have said whith the letter P or FL, then calculate c1 divided by 173, if it doesn't start with P or FL, enter 1
Any help is appreciated!
Help, I'm trying to enter an =if(or statement and can't seem to get it right.
I want to say if the cell (A1) states "terminated" enter a 0 if it doesn't state termimated then look into cell B1 if that starts with PT30 or PT then calculate c1 divided by 173, if it doesn't start with P or R...