Hello, I'm trying to get the following formula to work and getting syntax error that ) is missing. 
My goal is if Net Amount is over $7500, Approval Not Required and If Net Amount is Under $7500, Opportunity Type is New Annual License Or Product Code is JMPASSW-01. So Less than $7500 and Opportunity Type New Annual License or Less than $7500 and Product Code JMPASSW-01 would be Approval Required. 

IF(
     SBQQ__Quote__r.SBQQ__NetAmount__c > 7500,  
    "Approval Not Required",
    IF(ISPICKVAL( SBQQ__Quote__r.SBQQ__Opportunity2__r.Type, "New Annual License")OR SBQQ__ProductCode__c, "JMPASSW-01" 
        SBQQ__NetAmount__c <= 7500), "Approval Required ")))

Any help would be appreciated. Thanks. 

Hello,
In the formula below, I would like the outcome of the Formula to enter the correct image into the Deal Approval Required field. Green, Blue, Yellow, etc. The first part of the formula is working as expected, so Approval Not Required is being entered if amount >7500 is working, but rest of the formula is not working correctly. Any ideas or suggestions would be appreciated. Thanks.  

IF(
    SBQQ__NetAmount__c > 7500, 
    "Approval Not Required",
    IF(
        SBQQ__NetAmount__c <= 7500 && ISBLANK(CPQ_Approval_Level_MAX__c), 
        "Approval Required ",
        CASE(
    CPQ_Approval_Level_MAX__c,
    1, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hl9z&oid=00D8K0000004cJ1&lastMod=1652276904000', "Green"),
    2, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0158K0000000Xrs&oid=00D8K0000004cJ1&lastMod=1652276872000', 'Blue'),
    3, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hl9y&oid=00D8K0000004cJ1&lastMod=1652276772000', 'Yellow'),
    4, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hlA0&oid=00D8K0000004cJ1&lastMod=1652276863000', 'Red'),
    5, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hl9x&oid=00D8K0000004cJ1&lastMod=1652290642000', 'Black'),
    "N/A"
)
    )
)

Hello, I'm trying to get the following formula to work and getting syntax error that ) is missing. 
My goal is if Net Amount is over $7500, Approval Not Required and If Net Amount is Under $7500, Opportunity Type is New Annual License Or Product Code is JMPASSW-01. So Less than $7500 and Opportunity Type New Annual License or Less than $7500 and Product Code JMPASSW-01 would be Approval Required. 

IF(
     SBQQ__Quote__r.SBQQ__NetAmount__c > 7500,  
    "Approval Not Required",
    IF(ISPICKVAL( SBQQ__Quote__r.SBQQ__Opportunity2__r.Type, "New Annual License")OR SBQQ__ProductCode__c, "JMPASSW-01" 
        SBQQ__NetAmount__c <= 7500), "Approval Required ")))

Any help would be appreciated. Thanks. 

Hello,
In the formula below, I would like the outcome of the Formula to enter the correct image into the Deal Approval Required field. Green, Blue, Yellow, etc. The first part of the formula is working as expected, so Approval Not Required is being entered if amount >7500 is working, but rest of the formula is not working correctly. Any ideas or suggestions would be appreciated. Thanks.  

IF(
    SBQQ__NetAmount__c > 7500, 
    "Approval Not Required",
    IF(
        SBQQ__NetAmount__c <= 7500 && ISBLANK(CPQ_Approval_Level_MAX__c), 
        "Approval Required ",
        CASE(
    CPQ_Approval_Level_MAX__c,
    1, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hl9z&oid=00D8K0000004cJ1&lastMod=1652276904000', "Green"),
    2, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0158K0000000Xrs&oid=00D8K0000004cJ1&lastMod=1652276872000', 'Blue'),
    3, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hl9y&oid=00D8K0000004cJ1&lastMod=1652276772000', 'Yellow'),
    4, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hlA0&oid=00D8K0000004cJ1&lastMod=1652276863000', 'Red'),
    5, IMAGE('https://jmpsoftware--main2--c.documentforce.com/servlet/servlet.ImageServer?id=0155b000006hl9x&oid=00D8K0000004cJ1&lastMod=1652290642000', 'Black'),
    "N/A"
)
    )
)