Column has a formula, need answer as a multiplier
C Value column is a formula
=IF(ISBLANK([Solution #31 Correction Factor]@row), "", IF([Solution #31 Correction Factor]@row = 9.5, "1.05", IF([Solution #31 Correction Factor]@row = 10, "1", IF([Solution #31 Correction Factor]@row = 10.5, "0.95", IF([Solution #31 Correction Factor]@row = 11, "0.91", IF([Solution #31 Correction Factor]@row = 11.5, "0.87", IF([Solution #31 Correction Factor]@row = 12, "0.83", "Replace Solution")))))))
I need the response, in this case .83, to be multiplied against the Concentration result.
So I need = [Stage 11 62 Concentration]@row * ["C" Value]@row which gives an Invalid Operation.
Help? I am sure there is an easy answer.
Thanks!!
Answers
-
Hi Elizabeth Aird,
You can try the below formula in "C" Value column where I have made some syntax changes.
=IF(ISBLANK([Solution #31 Correction Factor]@row), " ", IF([Solution #31 Correction Factor]@row = 9.5, 1.05, IF([Solution #31 Correction Factor]@row = 10, 1, IF([Solution #31 Correction Factor]@row = 10.5, 0.95, IF([Solution #31 Correction Factor]@row = 11, 0.91, IF([Solution #31 Correction Factor]@row = 11.5, 0.87, IF([Solution #31 Correction Factor]@row = 12, 0.83, "Replace Solution")))))))
Thank You!
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
-
That worked.. thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!