Math Formula Error

Elliot Holder

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.

Paul Newcome

Are you getting an error or an incorrect result?

Elliot Holder

I'm getting back an #INVALID OPERATION

Paul Newcome

What are the formulas you are using to populate the Price and Impressions?

Elliot Holder

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!

Paul Newcome

That's pretty much where I was going with my last question. Glad you got it sorted. 👍️