0

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?

Improve this question

1 Answer 1

Reset to default
0

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.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.