IF INV__c AND MCP__c ="" then field= No MCP or INV
IF INV__c ≠ "" AND MCP__c ="" then field = Has MCP no INV
IF INV__c ="" AND MCP__c ≠"" then field = Has INV no MCP
IF INV__c AND MCP__c ≠"" then field = Has both MCP and INV
Ideas?
4 件の回答
Cory, your formula field will have to be of type Text and should have the following formula:
IF(
AND(
ISBLANK(INV__c),
ISBLANK(MCP__c)
), "No MCP or INV",
IF(
AND(
NOT(ISBLANK(INV__c)),
ISBLANK(MCP__c)
), "Has INV no MCP",
IF(
AND(
ISBLANK(INV__c),
NOT(ISBLANK(MCP__c))
), "Has MCP no INV",
IF(
AND(
NOT(ISBLANK(INV__c)),
NOT(ISBLANK(MCP__c))
), "Has both MCP and INV", NULL
)
)
)
)
