Microsoft Excel 010 - complete package

Please help me with the formula in an Excel Sheet:-

I need to get value one cell based on the % Achievement.

For e.g if A1 is 100 and B1 is 50 then C1 will be a formula Calculating the %.

Now in D1 the value should appear based on the %, if the % achievement is less than 49% then D1 should be A1-20%, but if C1 is more than 50% then D1 should be A1-80%.

re: " if the % achievement is less than 49%"re: "

if C1 is more than 50%"What happens if the %

equals49 - 50%?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Then D1 still remains A1-20%, sorry should have been more specific. it should be less than 49.99%.

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.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History