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
Check out the Formula Handbook template!