Multiple data validation for group of cells

[dkflameboy]

Hi,

Is it possible to create multiple data validations for a range of cells?

I want to ensure that cells B13-Q13 can only have a whole number between 0 and 100 entered, but the cells also need to accept the letter N to ensure that an IF formula further in the spreadsheet works.

I'm guessing it would be the custom option in validation but I can't even begin to figure out the formula.

Any help would be much appreciated.

Thank you.

 

[FormR]

Hi, welcome to the forum.

I'm guessing it would be the custom option in validation but I can't even begin to figure out the formula.

Yes, you will need a custom formula, here is one option you could try.

=OR(B13="N",AND(B13>=0,B13<=100,MOD(N(B13),1)=0))

 

[dkflameboy]

Hi, thank you, I have previously used this forum to find answers but never registered, I'm glad I have now and will probably use this quite a lot.

I have tried this formula and it works perfectly, thank you very much for your speedy response and for stopping me from stressing out!