Using IF Formula using two conditions

[WDGraham]

Hello to all,

I cant seem to rack my brain around how to go about making a formula in order to achieve my desired effect using the IF Formula. The data is as follows:
Worker Status %
S1 75% and higher
S2 42.8571% -74.9999%
SH Anything below 42.8571%

My sheet pulls the workers status from a preset data table, lets say S2 for Joe. I want the cell beside his status to compare what his percentage is and display what the status should be (based on the conditions of the above table). If hes working 73% it will turn up S2 and I can compare the value from the table and the value generated based on his working percentage (I would use conditional formatting to color the cell red or green to indicate if it matches or not.) ANy help on this would be greatly appreciated

 

[Salivan]

Let's say the percentage of Joe is at the cell A1

=IF(A1<42,8571%;"SH";IF(A1>=75%;S1;S2))

Is that what you want? Sorry if I missunderstood your question.

 

[WDGraham]

I couldnt seem to get it right with the formula you provided but I eneded up with this and it worked (K38 being where Joes % is)

=IF(K38<42.8571,"SH",IF(K38>74.9999,"S1",IF(K38<74.9999,IF(AND(K38>42.8571),"S2"))))

Pretty much the same as you had suggested. Much appreciated, wouldnt have been able to figure it out without your help. Had Excel-Block, couldnt get around this formula. Thanks again!