Sign in to follow this  
Fargo

Need Mooooore Excel Help Please

Recommended Posts

well this is what i need to do.

take a daily revenue value, minus £250, then what ever is left i need to apply 3 differnt commision rates to end up with a final value.

example:-

£350 less 250 = £100

commision rates are

2.5% for the first £50

5% for £75

10% for £100

now bear with me, this is where is gets tricky.

take the £100 and work out 2.5% for the first £50, then 5% for the next £25 (50+25 is 75)

then 10% on the remaining £25 (50+25+25 is 100)

example 2:-

£375 less 250 = 125

2.5% for the first 50

then 5% for the next 25

then 10% for the remaining 50....

good luck

Share this post


Link to post
Share on other sites

You also have incoming from me Paul.

Beat me to it though Steve, wonder if the solutions look anything like the same :lol:

Edited by MacRS200

Share this post


Link to post
Share on other sites

lol thanks guys,, got yours steve, is exactly what im after...

both the same result, both using differnt methods.

steve used =IF(B6>0,MIN(50,B6)*2.5%,0)

neil used =IF(B3<0,0,(IF(B3>50,50,B3)))

thanks again...

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this