Replace nested IF with other formulae...

[contaminated]

Hi
Ive got one question... just for interest...

A friend of mine is Fiscal Agent. He works at state tax administration. He had this formula at work to calculate income tax.

=IF(K16<=75,0,IF(AND(K16>75,K16<=200),(K16-75)*14%,IF(AND(K16>200,K16<=2000),K16*14%,IF(K16>2000,(K16-2000)*35%+280))))

I've reduced it. Now it looks like.

=IF(K19<=75,0,IF(K19<=200,(K19-75)*14%,IF(K19<=2000,K19*14%,(K19-2000)*35%+280)))

They're almost the same but I didn't use AND() function.

Now, my question is can this formula be replaced with SUMPRODUCT() or CHOOSE/MATCH ...I observed similar replacement but I don't remember details of that formulae.