=if or Formula Help!!!!

[Josie]

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, enter 1


Col A Col B Col C

Active PT 20

Terminated FT

Active FT


What I have so far =IF(OR(a1="terminated",0),(b1="PT30",b1="PT),M5/173.331,1)

It's not working, If it shows active it's enter "false" if Terminated it's doing the calculation but for for anything in c1 not enter 1 for other than PT30 or PT. HELP

 

[Luke M]

=IF(A1="terminated",0,IF(OR(LEFT(B1,1)={"P","R"}),C1/173,1))

 

[Josie]

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!

 

[Hui]

=IF(A1="terminated",0,IF(OR(LEFT(B1,1)="P",LEFT(B1,2)="FL"),C1/173,1))

 

[Josie]

Great, it worked!!! Thanks everyone!