Ensure Cell Only Accepts x Characters

  • hi!

    my formula is in B1. If in A1, there is letter Y, the value in B1 should accept only 3-digit numbers.

    guys, can you help me with the formula?

    Any help is very much appreciated.

    Thank you so much.

  • Re: Cell Accepts 3-digit Numbers Only

    Hi iiawak,

    This is my suggestion. Apply data validation in cell B1. Choose the "custom" type and under formula, type "=IF(A1="Y",LEN(B1)<=3,LEN(B1)>0)" (without the quotes).

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!