LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 102
Default 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","")))
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"