IF function syntax question

E

Elena

Hi, I appreciate any help with this problem. Thanks so much in advance!
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 need the formula to say:

Start in 'Total Fees' cell (O7)

Look in 'fee cell' (N7) IF N7 equals "YES" then,
Check if
If price in (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
 
E

Elena

Hi JE.
Thanks for the formula! Yep you guessed right. I'm trying to track my
auctions.
But the formula you suggested got an error message - "The formula you typed
contains an error. Can't figure it out, it's just too complicated for me.
Thanks for trying though. I tried to click on your link but the link was
broken.
"The requested URL /excel/variablerates.html was not found on this server."

Kind regards,
Elena
 

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