Bringing Formatting with the If state

K

Kathi

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.
 
G

Gary''s Student

Just apply the same custom format to the cell with the formula as in the
original cell.
 
K

Kathi

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.
 
Top