Hi I am struggling with what should be a straight forward sales / recompense calculation.
G is my variable "opportunities found" column where I imput the no. found per week.
I wish to change from a flat 8$ per opportunity to have a tierd increasing return.
so upto 30 pays $8 each then between 30 to 60 pays 10$ each and any over 60 pays $14.95
At moment I have =SUM(G12*8) for the flat result - Any help appreciated!
=IF(Opportunities<=30,Opportunities*8,IF(Opportunities<=60,Opportunities*10,Opportunities*14.95))
In the above formula, replace opportunities with your cell ref (G12).
Tgsekhar - Thanks I had almost the same here but It did'nt quite get there in the 3rd level
Thanks anyway
If your query is solved, please mark it as solved.
I read this as being tiered. Try this:
=SUMPRODUCT((A1-{0,30,60})*(A1>{0,30,60}),{8,2,4.95})
Where A1 holds your Opportunities.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
PaulyB - Thank you ! all sorted
Or with VLookup in an table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks