ShowAll Questionssorted byDate Posted
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!!!

Best Answer chosen by Admin (Salesforce Developers)
Ritesh Aswaney

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

Ritesh Aswaney

the syntax is

If (Condition, Value if true, Value if False)

So,

IF (Total_Event_Cost__c <> 0, Total_Event_Cost__c /  NumberOfWonOpportunities, 0  )

RoxyGirl

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!

Ritesh Aswaney

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  )

This was selected as the best answer
RoxyGirl

That did the trick,

Thank you SO much, you saved me a lot of time and hair pulling.

Take care

Ritesh Aswaney

No problem :)