Forum Discussion

batabyal2480's avatar
batabyal2480
Copper Contributor
Jul 28, 2024

Excel formula Help

Hi, How to include: IF Master!F11="Yes" in the following excel statement: IF(H27>1000000,(H27-1000000)*0.3+500000*0.2+200000*0.05,IF(H27>500000,(H27-500000)*0.2+200000*0.05,MAX((H27-300000)*0.05,0)...
Formulas and Functions
Harun24HR's avatar
Harun24HR
Silver Contributor
Jul 28, 2024
Try =IF(Master!F11="Yes",IF(H27>1000000,(H27-1000000)*0.3+500000*0.2+200000*0.05,IF(H27>500000,(H27-500000)*0.2+200000*0.05,MAX((H27-300000)*0.05,0))),"")
  • batabyal2480's avatar
    batabyal2480
    Copper Contributor
    Jul 28, 2024

    Harun24HR 

    It did work!! Thank you, Harun24HR!!!

    Now, in the same statement how to add

    IF Master!F11="No" then the following is true:

    IF(H27>1500000,(H27-1500000)*0.3+300000*0.2+300000*0.15+300000*0.1+300000*0.05,IF(H27>1200000,(H27-1200000)*0.2+300000*0.15+300000*0.1+300000*0.05,IF(H27>900000,(H27-900000)*0.15+300000*0.1+300000*0.05,IF(H27>600000,(H27-600000)*0.1+300000*0.05,MAX((H27-300000)*0.05,0)))))

    • Harun24HR's avatar
      Harun24HR
      Silver Contributor
      Jul 28, 2024

      batabyal2480 Put your second formula in place of last double quote.

      =IF(Master!F11="Yes",IF(H27>1000000,(H27-1000000)*0.3+500000*0.2+200000*0.05,IF(H27>500000,(H27-500000)*0.2+200000*0.05,MAX((H27-300000)*0.05,0))),IF(H27>1500000,(H27-1500000)*0.3+300000*0.2+300000*0.15+300000*0.1+300000*0.05,IF(H27>1200000,(H27-1200000)*0.2+300000*0.15+300000*0.1+300000*0.05,IF(H27>900000,(H27-900000)*0.15+300000*0.1+300000*0.05,IF(H27>600000,(H27-600000)*0.1+300000*0.05,MAX((H27-300000)*0.05,0))))))

       

       

      • batabyal2480's avatar
        batabyal2480
        Copper Contributor
        Jul 28, 2024
        It worked like magic!! Thanks a million, Harun24HR!!! Good day.