@IF formulas - multiple outcomes

Occasional Visitor

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

@whibley92 

=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.