Dan,

Maybe this

=IF(T206="Services Terminated-File Closed","$150.00 Admin Fee
Owed",IF(OR(T206="Services Terminated-Medical Dismissal",T206="No Show to
MOP"),"No Adminnistrative Fees Charged",""))

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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","")))