Sorry, typo
Formula:
=MIN(1500, F2-150)*0.35 +MAX(0, F2-150-1500)* IF(E2="A", 0.5,0.4)
Sorry, typo
Formula:
=MIN(1500, F2-150)*0.35 +MAX(0, F2-150-1500)* IF(E2="A", 0.5,0.4)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks