I am having a problem writing an IF function with multiple...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.apps.spreadsheets FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by lrobbins
Submitted on 10/20/2003
Related FAQ: comp.apps.spreadsheets FAQ
Rating:	Rate this question:
I am having a problem writing an IF function with multiple scenarios. If one cell equals, Sr or Jr, and the amount is within three different parameters, then calculate the amount using the percentage from the Sr or Jr table. It is a commission schedule that say if you are a Sr sales rep or Jr sales rep and you sell between 0 and 1,000,000 you get 0%. If you sell 1,000,001 and 5,000,000 you get 1.5%, and anything over 5,000,000 you get 2.5%. The Jr table is the same with different threshholds. Someone please help me.

Answer by LillyAnn
Submitted on 12/10/2003
Rating:	Rate this answer:
having problem writing a if function. The function should keep the cell blank if no value has been entered in the number of years cell if not the pmt function should performed and enter a value

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: