Decision formula

Hello everyone,

Ill start of introducing myself. I'm Bram and I live in Holland. I'm 18 years old and in need of some expertise.

I have the following problem:
I have an assignment for which I need to make a formula that has the function when a number is lower than 4 it has to say in the box next to it "Failed", if the number is between 4 and 6 it has to say "Retry", and if the number is above 6 it has to say "Passed".

I know this is probably not that hard to make but I have been trying for 45 min. and haven't gotten anywhere

Thanks already,

Bram

First of all thanks NBVC,

But I'm still getting an error message when I try to enter the formula. (It highlights the A1 part which in my case is G6)

Any idea on what could solve this?

Thanks for the code. It doesn't give the error anymore but now it says that it's an improper name. (Not sure if I translated it right, I have the Dutch version of Excel)
From what I can tell Excel doesn't know the =Lookup term.

Thank u so much.