|You still haven't clarified your requirements, you've simply narrowed the gap.|
From Response #2:
"it should be less than 49.99%."
From your original post:
"if C1 is more than 50% then D1 should be A1-80%. "
That still leaves 49.99 through 50 unaccounted for.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.