Sha-la-la-la-la ~~  hohoho!  You may not realise how happy I am right now.
but nevermind :)

I finally managed to figure out the correct formula for my commission calculation report.

At first I faced the trouble since yesterday with the many levels of IFs in that (stupid) formula.
*scratching ma head*

And just now, my mind suddenly twisted towards the right direction and PRESTO! Got it right :D


I would surely preserve this one !
=IF($H8<101,
        IF($I8<1,0,
              IF($I8<2,J8*0.05,
                    IF($I8<3,J8*0.03,
                          IF($I8<4,J8*0.02,
                               IF($I8<5,J8*0.015,0))))),
IF($H8<102,
       IF($I8<1,0,
            IF($I8<2,J8*0.09,
                  IF($I8<3,J8*0.04,
                        IF($I8<5,J8*0.02,0)))),
IF($H8<103,
       IF($I8<1,0,
             IF($I8<2,J8*0.06,
                   IF($I8<3,J8*0.03,
                         IF($I8<4,J8*0.02,
                               IF($I8<5,J8*0.015,0))))),
IF($I8<1,0,
       IF($I8<2,J8*0.35,
             IF($I8<3,J8*0.25,
                   IF($I8<5,J8*0.15,
                         IF($I8<7,J8*0.1,0))))))))


Now its part 2...=.=