How JustAnswer Works:
• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
Ask Richard Your Own Question
Richard, Software Engineer
Category: Microsoft
Satisfied Customers: 43199
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Question Here...
Richard is online now

# I need help writing an excel formula with IF functions...

### Customer Question

I need help writing an excel formula with IF functions...
Submitted: 3 years ago.
Category: Microsoft
Expert:  Richard replied 3 years ago.
Thank you for your question, my name is XXXXX XXXXX I look forward to assisting you.

Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.

Can you give me the complete set of rules for the formula?

And provide me the sheet please so I can do this for you.

To give me the sheet, do the below instructions.

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 3 years ago.

280084

HI, Thanks. File ID above.

I need to calculate commission payable over Threshold (T) on a tiered basis where the first 15k over threshold is paid at 25%, from 15k to 22.5k over threshold at 30% and from 22.5k+ over threshold at 40%.

So, for example,

if someone had a threshold of 28450 and billed 58450 (30k over threshold) they would receive the following commission:

0-15 @25 % = 3750

15-22.5 @30% = 2250

22.5-30 @40% = 3000

TOTAL = 5250

Expert:  Richard replied 3 years ago.
Thanks, XXXXX XXXXX this now

Expert:  Richard replied 3 years ago.
I have done this Isobel

You can download it from www.wikisend.com under File ID 354616

Test it and Let me know the results please

Thank you
Customer: replied 3 years ago.

HI the file that downloaded doesn't contain anything other than i uploaded. could you save and resend please?

thanks

Expert:  Richard replied 3 years ago.
The formula is in H4 Isobel,

I double checked and it is there.

Customer: replied 3 years ago.

I see, sorry I obviously wasn't clear:

I need the formula for each tier (cells in column D, E and F) to be calculated at the rate applicable based on the value in Column C.

I need to show the amount paid at each tier, not just the total.

Thanks!

Expert:  Richard replied 3 years ago.
ok, that is done under File ID 585724

Customer: replied 3 years ago.

HI

I've uploaded the file with the longhand version of what i'm trying to achieve in the cells. See example 2 on file 482612.

Thanks!

Expert:  Richard replied 3 years ago.
ok... not sure what was wrong with mine, but doing it again in the other cells.
Expert:  Richard replied 3 years ago.
Isobel,

I uploaded it an hour ago, but I see it never appeared.

My apologies for this, I have uploaded it again.

File ID 274850

I am sorry about that.

Let me know if you have any difficulties please
Customer: replied 3 years ago.

147360

Hi

I just downloaded your file and populated column C. The formula is doing something strange. The results should be the same as example 1.

Thanks

Expert:  Richard replied 3 years ago.
Thanks

I corrected it, can you check it please?

ID 673804

Let me know the results please

thank you
Customer: replied 3 years ago.

317818

40% column returns incorrect figs when other fields populated. should be calculated on the portion above 22500 over T

have worked it out separately. thanks,

Expert:  Richard replied 3 years ago.
Good to hear Isobel.

We just needed to create an understanding of your exact requirements.

If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Customer: replied 3 years ago.

HI

I had to have someone else do this as needed it last night and your answer wasn't consistent with what I had requested.

Thanks for your efforts and I appreciate the speed.

Isobel

Expert:  Richard replied 3 years ago.
I did what you initially needed

I need to calculate commission payable over Threshold (T) on a tiered basis where the first 15k over threshold is paid at 25%, from 15k to 22.5k over threshold at 30% and from 22.5k+ over threshold at 40%.

But then you wanted it broken down, then in different locations ect, so this is why it kept changing.