Ask Search:
Denise CermanskiDenise Cermanski 

Need help creating a custom formula with IF, AND criteria

I would like to create a custom formula field with the folllowing conditions:

npo02__LastCloseDate__c is greater than September 1, 2017
and
(npo02__LastOppAmount__c)  is greater than 1 and less than 100

THEN the text "Level 1" should appear

Can someone help?

Thank you!
Best Answer chosen by Denise Cermanski
Deepak AnandDeepak Anand
Here you go = 
IF(
    AND(
        npo02__LastCloseDate__c > DATE(2017, 09, 01),
        npo02__LastOppAmount__c > 1,
        npo02__LastOppAmount__c < 100
    ),
    "Level 1",
    NULL
)

All Answers

Deepak AnandDeepak Anand
Here you go = 
IF(
    AND(
        npo02__LastCloseDate__c > DATE(2017, 09, 01),
        npo02__LastOppAmount__c > 1,
        npo02__LastOppAmount__c < 100
    ),
    "Level 1",
    NULL
)
This was selected as the best answer
Denise CermanskiDenise Cermanski
Thank you!