Hi bdev,
Welcome to the forum.
You said..for anything over, we pay 15%.. I guess this is for over and above amount after 11600000.. try below formula:-
=IF(A1<=11600000,174000,(11600000-174000)*15%)
Regards,
DILIPandey
<click on below 'star' if this helps>
Bookmarks