Simple row multiplication formula
Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row.
For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15%
I am multiplying 1 row by a fixed number. I am not multiplying two rows together.
What's the correct way to achieve this?
Best Answer
-
Option 1: a simple formula
Option 2: an additional markup column
Option 3: sheet summary
Answers
-
This way works. It does depend on what you are trying to achieve and the future plans.
For example, can the mark up change in the future? If you place the 15% in the formula then you have to go back and change it which can be tiresome if you have a lot of rows.
An option is to make a sheet summary field called markup with the 15%. And reference in the formula cost@row*markup#
-
I guess I don't quite understand what you're suggesting
-
Option 1: a simple formula
Option 2: an additional markup column
Option 3: sheet summary
-
I have a column named Price Bought
I did
=Price Bought@row * 1.15
but I got #UNPARSEABLE
-
I was able to do =[Price Bought]@row * 1.15 and that did the trick, thank you!
-
Yes, you need to use [ ] whenever the column name has a space
-
Excellent info, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!