Results 1 to 4 of 4

Nested If Statement Help

Threaded View

  1. #1
    Registered User
    Join Date
    08-27-2007
    Location
    San Antonio Texas
    Posts
    41

    Nested If Statement Help

    Hello again - I'm trying to get column I of the attached spreadsheet to calculate selling fees at a product level, and there are (apparently) one or more issues with the following formula:

    =IF(C2="eBay" and D2>=.01 and <=25,D2*.0525,IF(C2="eBay" and D2>=25.01 and <=1000,1.31+(.0325*D2-25),IF(C2="eBay" and D2>=1000.01,33+(.015*D2-1000.01),0)))

    It is supposed to look at the value in column c, and if the product is listed in our eBay store it should calculate the selling fee based on the following:

    Final Value (Selling) Fees
    Closing Price Final Value Fee
    >= $0.01 and <= $25.00 5.25% of the closing value
    >= $25.01 and <= $1,000.00 5.25% of the initial $25.00 ($1.31), plus 3.25% of the remaining closing value balance ($25.01 to $1,000.00)
    >= $1,000.01 5.25% of the initial*$25.00 ($1.31), plus 3.25% of the initial*$25.01 -*$1,000.00 ($31.69), plus 1.50% of the remaining closing value balance ($1000.01 - closing value)

    I've attached a sample of the data I'm working with. If someone could point out the problem(s) with the formula above I'd really appreciate it. Thanks in advance.

    Marcus
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1