#UNPARSEABLE Error Division, Multiplication and Sum in one equation

Options

Hello,

I have the below. I'm trying to divide Contr17 and then multiply it against

=((VALUE(Contr17)/ 12) * VALUE([Jan Cost]14))+VALUE([Mar Cost]16))


Here it is written with numbers:

= ((100/12) * (40%)) + (500)


Thanks,

Amy

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!