Creating an "in-between" value in an If formula

[JinTHR]

Hello Everyone, Hope you are all doing well. Happy Friday! I have a question about values in an IF formula. Im trying to write an IF formula that will recognize a number between 0 and 1. When this number is inputted the formula will be TRUE, otherwise it will be FALSE. Here is my example:

=IF(1>A1>0,1,A1) (This formula doesn't work, but its what I'm trying to accomplish)

Let me know if anyone needs a better explanation and I will try my best.

Thanks everyone!

 

[chicagocomputerclasses]

=if(and(a1<1,a1>0),1,a1)

 

[Weazel]

maybe something like...

=AND(A1>0,A1<1)

 

[JinTHR]

Thank you so much for the help! I really appreciate it!

Take care!

 

[JinTHR]

Thank you so much for the help! I really appreciate it!

Take care!!