bandit_1981
Board Regular
- Joined
- Aug 17, 2005
- Messages
- 201
Hello all I am currently using this custom validation.
Now i need to update it to also allow for "." so they can have decimals in their percentage. Any Ideas. I tried putting
But this doesnt work
Code:
=AND(LEN(D6)<=8,OR(RIGHT((D6),1)="%",MOD(D6,1)=0))
Now i need to update it to also allow for "." so they can have decimals in their percentage. Any Ideas. I tried putting
Code:
=AND(LEN(D6)<=8,OR(RIGHT((D6),1)="%",OR val(FIND(D6,".")) > 0 ,MOD(D6,1)=0))