Bringing Formatting with the If state

  • Thread starter Thread starter Kathi
  • Start date Start date
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.
 
Just apply the same custom format to the cell with the formula as in the
original cell.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If condition for Blank Cell 4
Sum if not blank 4
Formula Check... Please 7
Show hours worked or Text "Day Off" 8
More than one IF Statement 5
Conflicting Conditional Formatting 1
If / Then based off conditional format 5
Bring in cell format 2

Back
Top