| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Messy Formula needs clean up help!
The Formula below works, but feels quite sloppy, and I'm sure it can be
accomplished in a much cleaner fashion. In addition, I attempted to add 1 more condition, but realized that I cannot add yet an 8th condition without receiving an error message (I believe the limit is 7). Any suggestions to clean the formula below up, and add the following 8th condition: =IF(A5="PD Reports Not Provided","$100.00" =IF(A5="Administrative Discharge Fee","$150.00",IF(A5="Medication Non Compliance Fee","$50.00",IF(A5="Taxi Fees","$10.00",IF(A5="Phase Program No Show Fee","$150.00",IF(A5="Record(s) Not Provided Fee","$100.00",IF(A5="BC Not Provided Fee","$50.00",IF(A5="File Re-Opening Fee","$150.00","")))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA not working - Messy. | Excel Worksheet Functions | |||
| Messy tab characters | Excel Discussion (Misc queries) | |||
| Transforming messy database into clean database | Excel Discussion (Misc queries) | |||
| Messy Text to Columns | Excel Discussion (Misc queries) | |||
| CLEAN Formula | Excel Worksheet Functions | |||
Threaded Mode
