i have a row
and i whant to limit the user to use only 1%-99%
how i do that with data validation but is dont work
thnks
i have a row
and i whant to limit the user to use only 1%-99%
how i do that with data validation but is dont work
thnks
datavalidation (formula)
=And(A1>=1%,A1<=99%)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Please refer the sheet.
Actually you can do this without formula
1. Go to Data Validation
2. Choose Decimal and Data as between
in Minimum enter 0.001 and in Maximum enter 0.99
Format cell(s) as Percentage
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks