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

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

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.

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?

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

Understood. Thanks again!

1 Like