Hi.

I have an problem with an if function. I have to get excel to understand that if attendance rises above cell G26 then the pay for the guards will be I26 and if the attendence is in between G27 and H27 then the pay for the guards will be I27 and if the attendance is below or equal to cell G28 then the pay for the guards must be I28.

Can someone please help?!