Assuming your value of 2,100 is in cell A1 then this should work ...=IF(A1<=75,A1*6,75*6+IF(A1<=1000,MAX(0,A1-75)*4,925*4)+MAX(0,A1-1000)*3)
Assuming your value of 2,100 is in cell A1 then this should work ...=IF(A1<=75,A1*6,75*6+IF(A1<=1000,MAX(0,A1-75)*4,925*4)+MAX(0,A1-1000)*3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks