Multiply cells with functions
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!
Best Answer

Use value function in order to apply math to it.
So =Hours@row * value([Trade Cost per Hour]@row)
Answers

@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

Use value function in order to apply math to it.
So =Hours@row * value([Trade Cost per Hour]@row)

That did it! Thanks so much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!