dkflameboy
New Member
- Joined
- Nov 28, 2016
- Messages
- 22
- Office Version
- 365
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.
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.