I am trying to a spreadsheet which calculates and returns a value according to its weighting,
so for example
70% £252
75% £270
80% £288
85% £306
90% £324
95% £342
100% £360
105% £378
110% £396
115% £414
120% £432
125% £450
fairly straight forward so far however what i need to be able to do is return a percentage of that value depending on its weighting.
on another tab i have 2 fields which determins the weighting and show it as a percentage, as well as the total percentage acheived in that field,
so what i want to be able to do is if say 120% is achieved but the tab showing the weighting as only say 10% i want it to display 10% of £432
im guessing it will be an if formula something along the lines of if field (which shows percentage achived is < 125% return field which shows weighting percentage of £450) and continue down all the values?
Last edited by Freeway85; 07-14-2011 at 11:21 AM. Reason: spelling
Sorry, I do not have the answer. But I am also looking for a way to do something VERY similar to this and I feel that if you get your answer, it will help me as well! I hope someone can give us the answer we are looking for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks