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

I am confused. If N3 >= 6/29/2010, then you want your result to be $9.95 or $4.95? or both value in a single cell?

If N3 >= 6/29/2010, it would be 9.95 but if cell Q3 contains "Add Web to Existing Print" or "Combo Subscription" then 4.95. Not sure how to incorporate using AND/OR statements.

Try

=IF(OR(Q3={"Add Web to Existing Print","Combo Subscription"}),IF(N3>=DATEVALUE("6/29/10"), 4.95, 4.5),IF(N3>= DATEVALUE("6/29/10"), 9.95,8.95))

Does that work for you?

At the beginning of the Excel General Forum folder is a "sticky" thread which has a lot of good sites. Most of what I know I learned on this site. I read through the threads and when I come across a question which I find interesting or which I think I might use, I subscribe to that thread (if the answer isn't posted yet) or review the answer. I then try them out in a workbook (or the posters workbook if he/she provided one) and save it under an appropriate name. Hope that helps.