• 100% Satisfaction Guarantee

Richard, Software Engineer
Category: Microsoft Office
Satisfied Customers: 33109
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office 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: 2 years ago.
Category: Microsoft Office
Expert:  Richard replied 2 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 2 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 2 years ago.
Thanks, XXXXX XXXXX this now

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

Test it and Let me know the results please

Thank you
Customer: replied 2 years ago.

thanks

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

I double checked and it is there.

Customer: replied 2 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 2 years ago.
ok, that is done under File ID 585724

Customer: replied 2 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 2 years ago.
ok... not sure what was wrong with mine, but doing it again in the other cells.
Expert:  Richard replied 2 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

Let me know if you have any difficulties please
Customer: replied 2 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 2 years ago.
Thanks

I corrected it, can you check it please?

ID 673804

Let me know the results please

thank you
Customer: replied 2 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 2 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 2 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 2 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.

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• ### jstinehelfer

#### Satisfied Customers:

23
A+ Comptia Certified computer repair
< Previous | Next >

### jstinehelfer

#### Satisfied Customers:

23
A+ Comptia Certified computer repair

### JasonJames122

#### Satisfied Customers:

0
I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

### Jess M.

#### Satisfied Customers:

239
Computer Software Specialist for more than 10 years

### KamilAnwar1

#### Satisfied Customers:

119
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

### Chris L.

#### Satisfied Customers:

111
Certified Expert with over 10 years experience.

### James K.

#### Satisfied Customers:

110
Technical Director of IT Company