Get the exact value based on % of Achievement

Microsoft Excel 010 - complete package
August 16, 2011 at 11:08:04
Specs: Windows XP
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%.



See More: Get the exact value based on % of Achievement

Report •


#1
August 16, 2011 at 19:11:59
re: "if the % achievement is less than 49%"

re: "if C1 is more than 50%"

What happens if the % equals 49 - 50%?

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


Report •

#2
August 19, 2011 at 08:21:20
Then D1 still remains A1-20%, sorry should have been more specific. it should be less than 49.99%.

Report •

#3
August 19, 2011 at 14:12:53
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.


Report •
Related Solutions


Ask Question