Link to home
Start Free TrialLog in
Avatar of Frank Sellers
Frank SellersFlag for United States of America

asked on

Format Percentage Cells, Restrict Values >100.001

Hi,

I have a percentage dilemma with Excel: I have ranges formatted as percentages and I'm tring to restrict the user from entering values greater than 100.001. Using Excel's Data Validation feature, the closest I can come to it and still force users to enter numbers and not text is:

     =AND(ISNUMBER(I7),I7<=100.001)

Although this looks like it would work, it doesn't. Users can't enter text, but it still allows them to enter values greater than 100.001. I tried reversing the formula but that didn't work, and neither did using Whole Numbers Data Validation - that wouldn't let me enter squat on a cell formatted as a percentage no matter what the maximum number was.

Any help would be greatly appreciated!

Thanks!
SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Frank Sellers

ASKER

Works perfectly! Thanks!