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

That worked.. thank you!!
Help Article Resources
Categories
Check out the Formula Handbook template!