🤔 How to: Use If-Then-Else to calculate formulas based on text in another column (w/pic)

Ask for Help
1

image
image1081×238 68.9 KB

image

In order to get a new Trade Price column to use a calculation based on the Spread Type, what is the correct syntax to use?

Thanks

2

Create a Math column for each potential calculation. Then use the IF column to return the correct math column value based on the spread type.

3

Thank for the reply. So to be clear on my end, what I am trying to do can’t be done the way I am describing, correct?

4

No. You cannot do math inside of an IF column.

5

Understood. Thanks again!

1 Like