IF function question

E

EV

Hi, I need to create a formula that looks at several cells, and
performs several functions and every time I try I get an invalid or
other error, so I'm having trouble with the syntax. I appreciate any
help with this problem. Thanks so much!

I need the formula to say:

If fee (N7) equal "YES" then,
In 'Total Fees' cell (O7)
If price (G7) equals $0 - $25, then multiply by 5.25% (other
worksheet!I27)
or
If price (G7) equals $25 - $1,000 then multiply by 5.25% (other
worksheet!I27) of the initial $25 ($1.31), plus 2.75% (other
worksheet!I28) of the remainder (up to 1000)
or
If price (G7) equals over $1,000 then multiply by 5.25% (other
worksheet!I27)of the initial $25 ($1.31), plus 2.75% (other
worksheet!I28) of the initial $25 - $1000 ($26.81), plus 1.50% (other
worksheet!I29) of the remainder ($1000.01 and up)
else,
If fee (N7) equal "No" then, "0"

Thanks for any help !!!
Regards,
E
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top