Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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",""))) |