Forum Discussion
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)...
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)))))
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))))))
- It worked like magic!! Thanks a million, Harun24HR!!! Good day.
- How to write Excel syntax in the program to conditionally display sheets Comp (2) and Comp (3) satisfying the following conditions:
IF Master!F11="No" then display Comp (2) worksheet
IF Master!F11="Yes" then display Comp (3) worksheet
If there is a solution in Excel (not VBA), please let me know and oblige.