# Column has a formula, need answer as a multiplier

Options
✭✭✭✭
edited 09/22/23

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!!

Tags:

• ✭✭✭✭✭
Options

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

• ✭✭✭✭
Options

That worked.. thank you!!

• ✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!