How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Engineer
Category: Microsoft Office
Satisfied Customers: 31236
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

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 2 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 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

I am sorry about that.

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.
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    232
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg KamilAnwar1's Avatar

    KamilAnwar1

    Office Specialist

    Satisfied Customers:

    118
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    111
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    110
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/SH/Shefin/2012-6-6_17328_1.64x64.jpg Shefin's Avatar

    Shefin

    Microsoft Office Specialist

    Satisfied Customers:

    55
    Working as Tech support specialist with a world famous computer manufacturer