| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting of the Returned Value of a Formula Q
I have the following formula below which I'm trying to format with regards
to the value returned from EndPeriod. Visble in the returned value field is 2002-19, but when it is returned through the formula below it returns 200219, I want it to display as 2002-19. I've tried inserting TEXT(EndPeriod,"####-##") in various parts of the formula below but its not working Any ideas? =IF(D9="","",IF(H9="No Date","",IF(INDEX(EndPeriod,MATCH(D9,EmployeeNames ,0))=0,"No Date",INDEX(EndPeriod,MATCH(D9,EmployeeNames,0)))) ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| Formatting in the formula bar | Excel Discussion (Misc queries) | |||
| Formula and Conditionl Formatting Help | Excel Worksheet Functions | |||
Threaded Mode
