Results 1 to 6 of 6

Error using nested IF statements

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2011
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2010
    Posts
    3

    Error using nested IF statements

    Hi,

    I am having a hard time creating a formula that returns results based on multiple cells and differing options within the cells.

    In the attached example, in cell U3, I would like the formula to return 9.95 if the date in cell N3 DATEVALUE is >=6/29/10 and 8.95 if not.

    Not too hard so far, but I also want it return 4.95 if N3 DATEVALUE is >=6/29/10 and 4.50 if not AND if cell Q3 contains "Add Web to Existing Print" or "Combo Subscription"

    Here is an example of what I came up with: =IF(N3>=DATEVALUE("6/29/10"),9.95,8.95) + IF((AND(N3>=DATEVALUE(“6/29/10”)),4.95,4.50,(IF((OR(Q3=”Add Web to Existing Print”,”Combo Subscription”))))

    I've spent two full days looking at various sites for help.

    Thanks in advance
    Attached Files Attached Files
    Last edited by KTWoo; 12-20-2011 at 06:07 PM.

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