Why let the user enter this percentage if you already know what it should be?. Just calculate it with this formula and set the cell to read-only.
Am I missing something obvious or didn't you tell the whole story?
Kees
Hi,
I have a spreadsheet whereby I want to limit the options for user input in a cell (list). AND I also want to run a check to make sure that the option selected meets certain criteria. So here is my dilemma: How do I allow a list and an if function to operate simultaneously using data validation?
Data: List = 35% or 70%, now here is my criteria for the 70% option: =IF(AND(E6>2.99,E6<9.99,E6<(D6*0.
),70%,35%)
So if someone chooses 70% but doesn't meet the requirements I want it to report an error msg.
Help!
Thanks much!

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic