Hi All,
I have an issue that I could not figure out and wanted to get some help from you guys:
What I want is as follows:
so have have different employees bringing different amounts of money in, what I need to do is to possibly create a nested code that calculates the amounts they will be paid based on different percentages, for example:
employee A has done jobs for $100, 300, 500, 1200, 100, 1250 (all entered horizontally)
I need to pay him 50% on jobs over $1000 and 40% on jobs under $1000.
Now, I am looking for a code that can calculate all these for me in one cell and sum them up in the same cell. So basically in one cell I want to calculate (100+300+500)*.40 + (1200+1250)*.50 = 360 + 1225 = $1585 (were the code automatically finds number under 1000 and multiply them by .4 and automatically finds the numbers over 1000 and multiply them by .5 and add up the results) . I would appreciate it if someone can help me with this issue.
Best,
Ash
Bookmarks