# Multiplication formula

Options
✭✭✭✭✭
edited 12/12/22

I need help multiplying two columns. One is a formula equaling a percentage, the other is the value of another column that is adding multiple columns together. I keep getting in invalid value error.

Colum - Probability - with the percentage looks like this:

Column - Total Software TCV - with the value that needs to be multiplied against the percentage looks like this:

Column - Weighted TCV (Software TCV * Probability) - that I keep getting the Invalid Value Error:

Any ideas what I am missing?

Tags:

• ✭✭✭✭✭✭
Options

In your Colum - Probability column, I notice you're using "25%" when assigning a value if the logical condition is True. Try removing the "" around the 25%.

You can instead assign either 25% or .25 in it's place. Do this for each percentage you're trying to assign in that formula.

Then a simple =[Probability %]@row * [Software TCV]@row

should work for you in your Column - Weighted TCV (Software TCV * Probability) column.

If wrapped with the VALUE formula, my testing resulted in the same. If that's the case, stick with the simpler formula above.

=VALUE([Probability %]@row) * [Software TCV]@row

Hope this helps!

BRgds,

-Ray

• ✭✭✭✭✭✭
Options

In your Colum - Probability column, I notice you're using "25%" when assigning a value if the logical condition is True. Try removing the "" around the 25%.

You can instead assign either 25% or .25 in it's place. Do this for each percentage you're trying to assign in that formula.

Then a simple =[Probability %]@row * [Software TCV]@row

should work for you in your Column - Weighted TCV (Software TCV * Probability) column.

If wrapped with the VALUE formula, my testing resulted in the same. If that's the case, stick with the simpler formula above.

=VALUE([Probability %]@row) * [Software TCV]@row

Hope this helps!

BRgds,

-Ray

• ✭✭✭✭✭
Options

Thanks Ray! Changing all the values to decimal points did the trick. I really appreciate your assistance with this!

• ✭✭✭✭✭✭
Options

No problem, happy to help. Glad it worked!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!