aigduke

Thanks for the advice. I got the formula to work, I just needed to change the order an put the section that included the discharge date at the top. Best, Adrienne

OK, so here's the mandate from the client for invoices for inpatient and outpatient accounts for outpatients if the admit date is between 7/1/2010 and 6/30/2011, (amount recovered-.07*amount recovered)*contingency percent. Otherwise it's just straight up Amount Recovered*percentage for outpatients. For inpatients, it's a bit more complicated... For admit dates between 7/1/2010 and 6/30/2011, it's (Amount recovered- .52*amount recovered)*contingenty percent. BUT, if the admit date is before 7/1/2011 and discharge date is after 6/30/2011 it's (Amount recovered- .26*amount recovered)*contingenty percent. Otherwise it's Amount Recovered*contingency percent for inpatients. I think I have most of it figured out, except for the inpatient part that considers the discharge date. Here's my formula that mostly works: ( Acct Type ≠ "Outpatient" and Discharge Date < 6/30/2011 and Admit Date < 7/1/2011; (Amount Recovered-.26*Amount Recovered)*Percentage; Acct Type ≠ "Outpatient" and Admit Date>7/1/2010 and Admit Date<6/30/2011 ; (Amount Recovered-.52*Amount Recovered)*Percentage; Acct Type = "Outpatient" and Admit Date>7/1/2010 and Admit Date<6/30/2011; (Amount Recovered - Amount Recovered*.07)*Percentage; Amount Recovered* Percentage) What am I doing wrong?!? I am ready to tear my hair out! Thanks so much for your attention. Best, Adrienne