Help me to solve the IF function in Excel

[Nyper]

Guys, I am a newbie to Excel and I'd like to know how I can make an IF function work with a number range in between a range of numbers. Let's say I want to say that IF B8 is equal to 9 up to 10, it is good. How can I do that?
because it is impossible for me. to run it as =IF (B8=9-10, “Good")

 

[Fluff]

Hi & welcome to MrExcel.
How about

=if(and(B8>=9,B8<=10),"Good","Bad")

 

[jtakw]

Hi,

Try this, change the requirements range as you like:

=IF(AND(B8>=9,B8<=10),"Good","Bad")

 

[Nyper]

Hi & welcome to MrExcel.
How about

=if(and(B8>=9,B8<=10),"Good","Bad")

Thanks it helped me out

 

[Fluff]

Glad we could help & thanks for the feedback.