Formula or report?
Need some guidance on a formula I'm trying to build. We have identical sheets gathering separate information and I need to gather that into a single formula to determine % of of sales. The formula I'm needing to build is:
(discount 1-discount 2-discount 3)/(sales-financed)
Discount 1, 2, 3, sales and financed are all on their own sheets an in the below format. However, I cannot seem to cross reference a sheet with just the "=" and I would like to build a formula to pull this without having to remake it every month. Is there a report or other tool that will make this easier? If not, what formula type should I be looking for to get this working? Or will I need to create helper columns for each in order to do what I want?
Any help is appreciated!
Answers
-
Have you tried cell linking? If the the amounts are already summed on their home sheets, you should be able to link them.
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!