|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2010, 03:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
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",""))) 
|
|
#2
May 12th, 2010, 03:29 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
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",""))
|
|
#3
May 12th, 2010, 03:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
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","")))
|
|
#4
May 12th, 2010, 03:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
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","")))
|
|
#5
May 12th, 2010, 04:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
Almost the
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","")) .
|
|
#6
May 12th, 2010, 04:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
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","")) .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
