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
Bookmarks