Using Excel/ IF function to show a specific value/ text

Hi,

I am new to the forum and looking for help as my knowledge of Excel is very simplistic.

I am currently trying to set up a document that records the Bradford factor and number of absences. I am hoping to auto populate based on the total absence what action needs to be taken.

I am trying to create the IF function to include the following conditions;

<10 No Action
<100 Meeting
<300 Verbal
<400 Disc
<600 Dismissed

I am hoping someone can advise or suggest a better function/ formula to use in Excel.

Thanks in advance

Jade

Hi,

Thank you all for your help. I have used these ideas and found a brilliant solution.

Regards,

Servert