Search the Q&A Archives

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

 Question by lrobbins Submitted on 10/20/2003 Related FAQ: comp.apps.spreadsheets FAQ Rating: Rate this question: N/A Worst Weak OK Good Great 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: N/A Worst Weak OK Good Great 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 answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

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.