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)))

Can anyone please help?

Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze 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
        Bronze 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))))))

         

         

Resources