Multiply cells with functions

Dan Pollino

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!

Michael Culley

Use value function in order to apply math to it.

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

Ryan Sides

@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

Michael Culley

Use value function in order to apply math to it.

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

Dan Pollino

That did it! Thanks so much!