I have 5 column, column1: choice with value(A,B), column2: single line of text(appears when I click option "A" from column1), column3: single line of text (appears when I click option "B" from column1), column4: single line of text (I enter amount in it), column5: Calculated column (that gives output). so I'm trying to get the sum in column5(when column2 multiplied by column4) or to get the sum in column5(when column3 multiplied by column4).

what formula I can apply in calculated column5?

1 Answer 1


You should be able to achieve this with the following formula:

=IF([column1] ="A", VALUE([column2])*VALUE([column4]), VALUE([column3])*VALUE([column4]))

It uses the VALUE formula for converting the text to number before multiplying operation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.