Formula Help

[Danny Boy]

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

 

[Glenn]

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

 

[Mike H]

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]

Hi Mike!

Actually your suggestion, flagged the "No Administrative Fee Charged"
option, versus the "$150.00 Admin Fee Owed" option. We are looking for the
"$150.00 Admin Fee Owed" option to flag when either "No Show to MOP", or
"Services Terminated-File Closed" is the toggled outcome in Column T.

Thanks Again, Dan

 

[Danny Boy]

Almost there:

Most of your suggestion works Glenn, except the last string of the formula:

IF(T206="Services Terminated-Medical Dismissal",
"No Adminnistrative Fees Charged",""))


If I toggle "Services Terminated-Medical Dismissal", than I should get the
flag response "No Administrative Fee Charged". Currently the formula is
returning a "False" outcome however. Everything else in the formula (per my
testing) works.

Dan

 

[Danny Boy]

I spoke too soon...........It works!!!! Sorry about that!!!!!!