If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Options
Excel and percentage question!!
Former Member
Posts: 1,876,323 The Mix Honorary Guru
in General Chat
For an excel whiz....
I'm trying to work out sales targets for my staff. I've put together a spreadsheet which shows their sales week by week over 5 weeks, adds it up to show their total sales over those 5 weeks, and then works out their average sales. I want to make a column which calculates their weekly target, which is 20% above their 5-week average, but I can't figure out how to do it!
Any formula tips?! I've been trying to do
=SUM(20/sales average*100)+sales average
but it doesn't seem to be working..... what have I done wrong?
I'm trying to work out sales targets for my staff. I've put together a spreadsheet which shows their sales week by week over 5 weeks, adds it up to show their total sales over those 5 weeks, and then works out their average sales. I want to make a column which calculates their weekly target, which is 20% above their 5-week average, but I can't figure out how to do it!
Any formula tips?! I've been trying to do
=SUM(20/sales average*100)+sales average
but it doesn't seem to be working..... what have I done wrong?
0
Comments