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
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!