I'm trying to create a simple formula that will add the sum of 2 cells, then multiply that sum by 50
Best Answer
-
Try:
=SUM([$/lb]3:[$ Prod Surcharge]3) / 50
Answers
-
Try:
=SUM([$/lb]3:[$ Prod Surcharge]3) / 50
-
Thank you, Michael. Yes this helped tremendously.
=SUM([$/lb]3:[$ Prod Surcharge]3) * 50
I added an asterisk (multiply) in lieu of the / (division) but your formula got me 99.9% of the way there. Much appreciated, sir.
-
Since I'm in awe of your genius right now, perhaps you could help me with another question that I've illustrated above. I'm trying to take the quantity from my inventory spreadsheet and have it populate the adjacent cell in another separate spreadsheet after selecting that inventory item from a single select dropdown menu in the adjacent cell. I'll owe you a crisp $5 bill if you can solve this one for me lol
-
I think it's quite simple: =IF([WIRE 1]42 = "L-61 (5/64) 60#", {Inventory Stock Control Range 2})
After =IF and entering the logical_expression, for value_if_true, click 'reference another sheet' and select the field you want to map over.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!