You need to sign in to do that
Don't have an account?
RoxyGirl
Need help with IF formula
I need to return a value of 0 if the field has 0, if the value is greater than 0 I need to divide by another field and return that value.
Here is the formula I have, it is giving me a syntax error saying incorrect paramaters expected 3 recieved 2
IF (Total_Event_Cost__c =0,0) > 0 / NumberOfWonOpportunities
Thank you!!!
I'm guessing then we check for both values being greater than zero before calculation, else return a default value of 0.
IF ((Total_Event_Cost__c > 0 && NumberOfWonOpportunities>0), Total_Event_Cost__c / NumberOfWonOpportunities, 0 )
All Answers
the syntax is
If (Condition, Value if true, Value if False)
So,
IF (Total_Event_Cost__c <> 0, Total_Event_Cost__c / NumberOfWonOpportunities, 0 )
Thank you for your reply, unfortunately it is still returning Error in my cost per closed deal field when the value in the numberofwonopportunities is 0
What I need to do is divide the total event cost by the number of won opps and return a value (which will appear in the cost per closed deal field) even if it is 0. Maybe I am doing this the wrong way but when there is a value greater than 0 it does calculate correctly, I am lost.
Any suggestions would be greatly appreciated.
Thanks!
I'm guessing then we check for both values being greater than zero before calculation, else return a default value of 0.
IF ((Total_Event_Cost__c > 0 && NumberOfWonOpportunities>0), Total_Event_Cost__c / NumberOfWonOpportunities, 0 )
That did the trick,
Thank you SO much, you saved me a lot of time and hair pulling.
Take care
No problem :)