+ Start a Discussion
Megan Hooser 7Megan Hooser 7 

Formula syntax issue

Can someone help me figure out my syntax issues? 
Looking to have the formula evaluate if the created date is greater then the date, run the first calucaltion, if the date was prior, run the second calcualtion.

IF(DATEVALUE(CreatedDate)>(6/20/2017), 
(Total_Material_Cost__c*(1+Proposal__r.Opportunity__r.Account.Mark_upproject__c)),
((Total_Material_Cost__c * 1.7241 ) * 1.07526))
Best Answer chosen by Megan Hooser 7
VamsiVamsi
Hi,

Please try the below 

IF(DATEVALUE(CreatedDate)> DATE(2017,6,20), 
(Total_Material_Cost__c*(1+Proposal__r.Opportunity__r.Account.Mark_upproject__c)),
((Total_Material_Cost__c * 1.7241 ) * 1.07526))


Please mark as best answer if the above helps ..!!

All Answers

VamsiVamsi
Hi,

Please try the below 

IF(DATEVALUE(CreatedDate)> DATE(2017,6,20), 
(Total_Material_Cost__c*(1+Proposal__r.Opportunity__r.Account.Mark_upproject__c)),
((Total_Material_Cost__c * 1.7241 ) * 1.07526))


Please mark as best answer if the above helps ..!!
This was selected as the best answer
Megan Hooser 7Megan Hooser 7
Perfect, thank you!
VamsiVamsi
Hi Megan,

Please mark as best answer ..!!! So that it closes the question and we can help keep the forum clean..

Thanks !!