# Simple Multiplication

✭✭✭

Help! For some reason this simple multiplication is not working. I would like to multiply the Value (dollars) by the Workshare (%) and have the result return in the "Valued Based on Workshare" column.

• ✭✭✭✭✭✭

Try removing the quotes and making them decimals then formatting the column as a percentage.

=IF(Role@row = "Prime", 0.80, 0.30)

Then you should be able to do the basic multiplication of

=Value@row * Workshare@row

• ✭✭✭✭✭✭

Hi! What is the formula you are writing?

You should be able to get: =Value@row * Workshare@row to return a value in your Value Based on Workshare Column.

If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

• ✭✭✭

I tried that, as well as =Value@row * (1+Workshare@row), and keep getting #INVALID OPERATION. I just tried to remove the formula that was in the "Workshare" column and hard code the percentage, and it worked. I guess I will just hard code the percentages then...

• ✭✭✭✭✭✭

It sounds like we just need to adjust the formula in the % column. What is the formula you currently have in there?

• ✭✭✭

The formula was =IF(Role@row = "Prime", "80%", "30%")

• ✭✭✭✭✭✭

Try removing the quotes and making them decimals then formatting the column as a percentage.

=IF(Role@row = "Prime", 0.80, 0.30)

Then you should be able to do the basic multiplication of

=Value@row * Workshare@row

• ✭✭✭

That worked! Thank you so much!!!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!