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 Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History