Excell formula in MS Access

[Leadparsons]

Hi All,

Have a new problem.
I have 3 columns in excel and a 4th with a formula

Main Reject Return 60 days
27/08/2014 21/10/2014 22/10/2014 21/12/2014
24/01/2015 25/01/2015 DO REJECTIONS
17/02/2015 18/04/2015

"Main" is the first input date
"Reject" is the date it gets rejected
"Return" is the date returned after Reject

The 4th column needs to show 60 days from the "Main" date, "Do Rejections" if a date is in "Reject" and 60 days from "Return" date

Excel I use"=IF(AND(B2>0,C2>0),C2+60,IF(AND(B2>0,C2<1),"DO REJECTIONS",IF(AND(B2<1,A2>0),A2+60,0)))"

In a query I am using the expression builder and:

I Have tried IIF(AND([Reject]>0,[Return]>0),[Return]+60,IIF(AND([Reject]>0,[Return]<1),"DO REJECTIONS",IIF(AND([Reject]<1,Main]>0),[Main]+60,0)))

I Have also tried IIF([Reject]>0,[Return]>0),[Return]+60,IIF([Reject]>0,[Return]<1),"DO REJECTIONS",IIF([Reject]<1,Main]>0),[Main]+60,0)))

Can anyone help ?

 

[Joe4]

Cross-posted here: http://www.mrexcel.com/forum/excel-questions/849090-access-excel-formula-comparison-2.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).