@IF formulas - multiple outcomes

Copper Contributor

Hi, I'm trying to create a formula for Form Assembly connecting with Salesforce. I know nothing to do with Excel but thought the logic might apply.


We have one field which is a picklist of 3 different prices.


Each price creates a record.


What would the if formula be for it?


@if PICKLIST is PRICE1 do this, PRICE 2 do this, PRICE 3 do this.

1 Reply


=IF(A1=5,"do this",IF(A1=10,"do that",IF(A1=15,"do else","")))

If the cell with the picklist is A1 you can try this formula. In the formula the prices are 5, 10 or 15. You can replace "do this/that/else" with a calculation for example.