Merging two similar data validation formulas in to one

[dkflameboy]

Hi Everyone,

I have a further issue with a data validation formula that I need help on. I got the following data validation formula from one of you wonderful people the other day and I need to keep this formula:

=AND(COUNT($B$13:$Q$13)<11,OR(B13="na",AND(ISNUMBER(B13),B13>=0,B13<=100)))

But I also need to incorporate whatever the additional functionality is of this following formula:

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

Sorry, but my understanding the differences between the two is shockingly poor, can anybody please help?

Many thanks.

 

[BQardi]

You already have most of it, so it seems you just need to add the part in red:

=AND(COUNT($B$13:$Q$13)<11,OR(B13="na",AND(ISNUMBER(B13),B13>=0,B13<=100[B][COLOR=#ff0000],MOD(N(B13),1)=0[/COLOR][/B])))

 

[dkflameboy]

Once again, thank you very much, I'm so glad I have found this site.

 

[BQardi]

You are very welcome