Forum Discussion

whibley92's avatar
whibley92
Copper Contributor
Dec 14, 2022

@IF formulas - multiple outcomes

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.

admin
developer
excel
Formulas and Functions

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 14, 2022

    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.

     

     

Resources