If Statement formula - Answers - Salesforce Trailblazer Community
Ask Search:
Kristen OchryKristen Ochry 

If Statement formula

Having issues with what I think should be an easy IF Statement. I want the formula to check if the Line of Business field on the opportunity product ' Subscription, if so then multiply the Qty x the List Price x 12, if not return a 0. I have started with this - IF(Line_of_Business__c, "Subscription", (Quantity * ListPrice * 12), 0), but it's not quite cutting it. Any help would be greatly appreciated.
Best Answer chosen by Kristen Ochry
Deepak K AnandDeepak K Anand
Like this = 
IF(
    TEXT(Line_of_Business__c) = "Subscription",
    Quantity * ListPrice * 12,
    0
)

All Answers

Deepak K AnandDeepak K Anand
Like this = 
IF(
    TEXT(Line_of_Business__c) = "Subscription",
    Quantity * ListPrice * 12,
    0
)
This was selected as the best answer
Kristen OchryKristen Ochry
That's it, thank you so much!!!