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.
Best Answer

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
Answers

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