[Excel] Anonymous member's Question



  1. The basic salary data should be in Col A

  2. Please copy this formula to Cell E2 and drag down
    3.             
=IF(A2<=9000,MAX(A2*0.55,5000),
IF(AND(A2>=9001,A2<=15000),MAX(A2*0.5,5400)))
  3. Done




Source: ---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

© 2023 sunnypeaceisland.com