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