Prev: If date matches and formula hasn't already been calculated previou
Next: IF formula help?
From: Danny Boy on 12 May 2010 11:55
I spoke too soon...........It works!!!! Sorry about that!!!!!!

"Glenn" wrote:

> Danny Boy wrote:
> > VThis formuula below needs some help. We had it working, but want to add in
> > one piece. If "No Show to MOP" is added on Column T, we want Column U to also
> > say "$150.00 owed". It does say this if we toggle to "Services
> > Termiinated-File Closed", but not with "No Show to MOP". Any suggestions for
> > altering the formula below to work in both the "No Show" and "Services
> > Terminated" options?
> >
> > Thanks......Below is the formula we are trying to work with....Dan
> >
> > =IF(T206="Services Terminated-File Closed","$150.00 Admin Fee
> > Owed",IF(T206="Services Terminated-Medical Dismissal",OR(T206="No Show to
> > MOP","No Adminnistrative Fees Charged","")))
>
> Just a guess, because your formula above is non-functioning...
>
> =IF(OR(T206="Services Terminated-File Closed",T206="No Show to MOP"),
> "$150.00 Admin Fee Owed",
> IF(T206="Services Terminated-Medical Dismissal",
> "No Adminnistrative Fees Charged",""))
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: If date matches and formula hasn't already been calculated previou
Next: IF formula help?