Multiplication of a number and the result of a formula
Hello,
I'm trying to multiply a number and the result of a formula (also a number) but it says "INVALID OPERATION", any ideas please.
Thank you
Best Answer
-
Hi @Jlind
It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?
Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:
=Volume@row * VALUE([Baselined?]@row)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hey @Jlind
Is it possible to share your formulas (both of them)? It is almost impossible without more information for the community to guess what might be causing your error. Also a screenshot of your sheet is always helpful (and usually helps get faster response from the community).
With the additional info someone from the community will be glad to help.
Kelly
-
Sure,
Please see below, the number is the first column and the formula is the second column.
-
Hi @Jlind
It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?
Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:
=Volume@row * VALUE([Baselined?]@row)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives