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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!