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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bringing Formatting with the If state
Just apply the same custom format to the cell with the formula as in the
original cell. -- Gary''s Student - gsnu200781 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bringing Formatting with the If state
I am looking for it to automatically read the format and bring it over
because it will not be the same for each row. Some may be EA, Some may be H and some may be FT. "Gary''s Student" wrote: Just apply the same custom format to the cell with the formula as in the original cell. -- Gary''s Student - gsnu200781 |
Reply |
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 |