# Excel formula Help

Copper Contributor

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

4 Replies

# Re: Excel formula Help

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

# Re: Excel formula Help

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

# Re: Excel formula Help

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

# Re: Excel formula Help

It worked like magic!! Thanks a million, Harun24HR!!! Good day.