Hey - completely novice excel user trying to get my head round a line of algorithm...
Im trying to tier an IF statement... basically over 100% you get 10% of a value, between 110-120% you get 20% of a value, and 120% you get 30% of a value.
the 666 is a standard commission payment made after getting over 100% which is why its in every part.
My code is like this...
IF(F2<100, 0, IF(F2>=100 AND <110, (((E2-D2)*0.1)+666)), IF(F2>=110 AND <120, (((E2-D2)*0.2)+666)), (((E2-D2)*0.3)+666))
Excell telling me its wrong - but I cant see why!!
help please?
Bookmarks