Skip to main content
Topics#Ask An ExpertFrage von AMAN RANA
AMAN RANA (Always a Learner) fragte in #Ask An Expert
19. März 2019, 08:40

Having a problem with the formula field where i have to show if salary is less than 100000 then it'll 100% off in the fee and answer will be zero

4 Antworten
  1. Narender Singh (-)
    19. März 2019, 10:20

    Like this then:

    IF(Salary__c < 100000, 0,
    IF( AND(Salary__c > 100000, Salary__c < 500000 ), 0.5*Salary__c,
    NULL
    ))

     

     
Antwort schreiben...
0/9000