Hi everyone
I'm doing an TAFE assignment on spreadsheets and I'm having real trouble with this question: insert formulas to calculate the store with the highest total sales. This is a screenshot of my spreadsheet.
Screenshot (84).png
Any ideas are appreciated!
as this is an assignment and learning, rather than give you an answer - perhaps you could tell us what you have tried so far
what you think maybe useful to find the highest total sales ,
what would be an excel function that would find the highest or lowest number in a range ?
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks