IF function syntax question

[Guest]

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

 

[JE McGimpsey]

Ebay, right?

I'd set it up differently:


=ROUND(SUMPRODUCT(--(G7>{0,25,1000}),(G7-{0,25,1000}),{0.0525,-0.025,-0.0
125}),2)*(N7="YES")

You can find other variations, including using a table of rates at

http://www.mcgimpsey.com/excel/variablerates.html

 

[Guest]

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

 

[JE McGimpsey]

There was an extra "s". Try:

http://www.mcgimpsey.com/excel/variablerate.html