| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bringing Formatting with the If state
I have an If statement that returns the correct value but does not bring the
custom format of the original cell. Does anyone know how to bring the same format over with the result? Formula: =IF(Detail!E23="Not assigned",IF(Detail!D23="not assigned",Detail!C23,Detail!D23),Detail!E23) Result comes over as 6.00 and what I want is 6.000 EA which is what the original cell has customer formatted. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
| bringing data in from another worksheet | Excel Discussion (Misc queries) | |||
| bringing data in from one worksheet to another | Excel Worksheet Functions | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| Bringing together data | Excel Worksheet Functions | |||
Threaded Mode
