Forum Discussion
@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 diff...
=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.