# Multiply cells with functions

Options
✭✭✭

Good morning,

I'm trying to multiply two cells but one of them is derived from an IF function and the multiply won't work because of it. I'm trying to get the cost impact by multiplying the hours and trade cost cells. The trade cost cell uses the IF function below. Any help would be greatly appreciated!

• ✭✭✭✭✭
Options

Use value function in order to apply math to it.

So =Hours@row * value([Trade Cost per Hour]@row)

• ✭✭✭✭✭✭
Options

@Dan Pollino Hi Dan, this is because your formula is resulting in text, not numbers because you have the double quotes around your dollar amounts.

Remove the double quotes in your if formula and remove the \$ dollar symbols and your multiplication formula will work.

You can then use the "Currency format" button in the top icons to format your column like \$'s.

Does that make sense?

Ryan

Ryan Sides

Come Say Hello!

• ✭✭✭✭✭
Options

Use value function in order to apply math to it.

So =Hours@row * value([Trade Cost per Hour]@row)

• ✭✭✭
Options

That did it! Thanks so much!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!