NEED HELP WITH DIFFICULT FORMULA
Posted by Jennifer Jadin on February 07, 2002 8:56 AM
I hope that someone here can help me. I am some what knowledgable about Excel Functions and Formula but this one is over my head. PLEASE HELP! I am looking for a formula that will do the following...... If Cell F5 is > than or = to $50,000 and < than or = to $74,999 then multiply by .75%, or if cell F5 is > than or = to $75,000 and < then or = to $99,999 then multiply by 1%, or if F5 is > than or = to $100,000 than multiply by 1.5%.