Greater than but less than formula

[Guest]

Hello.

Is there a formula that will allow me to do a certain function if:
the value of a cell is (for example) greater than 5 but less than 8?

I appreciate any help.

Thanks,
Storm

 

[Guest]

=if(and(A1>5,A1<8),true,false)

 

[Guest]

Thank you very much!

=if(and(A1>5,A1<8),true,false)

 

[Guest]

No need IF function

AND(A1>5,A1<8)

=if(and(A1>5,A1<8),true,false)