Prev: If date matches and formula hasn't already been calculated previou
Next: IF formula help?
From: Danny Boy on 12 May 2010 10:11
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","")))
From: Glenn on 12 May 2010 10:29
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",""))
From: Mike H on 12 May 2010 10:33
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","")))
From: Danny Boy on 12 May 2010 10:53
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

"Mike H" wrote:

> 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","")))
From: Danny Boy on 12 May 2010 11:51
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

"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",""))
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: If date matches and formula hasn't already been calculated previou
Next: IF formula help?