Math Formula Error
Hi, I am trying to create a formula to divide the Impressions column by 1,000 then multiply it by the Total Price column. This is the formula I am using "=VALUE(Impressions@row / 1000) * VALUE([Total Price]@row)". Not sure what's going wrong. Total price is a column formula that auto fills each cell with the $5.95 price and Impressions is a column formula with a long if/then statement based off of the Confirmed Bag Qty column.
Answers
-
Are you getting an error or an incorrect result?
-
I'm getting back an #INVALID OPERATION
-
What are the formulas you are using to populate the Price and Impressions?
-
I got it figured out. I had to use the RIGHT([Total Price]@row,4) to remove the dollar sign. I'm rebuilding to have non-currency columns for formulas and display columns that use the currency signs. Thanks though!
-
That's pretty much where I was going with my last question. Glad you got it sorted. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
