Allowing multiple zeroes

[koconnell]

Hello, I have a sheet where values are entered into one cell and if they match a criteria a results cell allows pass or fail.
e.g. a value must be between 1-5, if it is within this range, Pass, otherwise Fail.
However one cell must match 00000000, the issue is that this changes to just 0 when the value is entered. Zeros must be allowed as sometimes the ranges vary into minus numbers e.g. -5 to 5
Thank you in advance for any help.

 

[miss_ell]

Hello,

Assuming that only when inputting 0 results in 00000000 and all other numbers remain the same, then in the input cell (say A1) change the custom format to 0;-0;00000000 then enter the following formula in B1:

=IF(AND(A1>=-5,A1<=5),"PASS","FAIL")

I hope this helps.

 

[koconnell]

Sorry I meant that 00000000 turns to 0 and I want it to stay the same.

 

[miss_ell]

Hello,

Did you try the solution I've posted to see if it works for you?