Thread: Formatting cell with text and formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default Formatting cell with text and formula
hi
when you mix text with numbesr, you loose the normal format abilities and
generally have to force formating on the number parts.
try something like this
=IF(K52=181044, "OK", "Off $" & Round(181044-K52,2))

regards
FSt1

"AHizon via OfficeKB.com" wrote:

I have the below formula:
=IF(K52=181044, "OK", "Off $" & 181044-K52)

Even after I format the cell to not have decimals, it still displays the
decimals to the 13th exponential. How can I set it so that it maxes at 2
decimals even if the cell has text and numerical value?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1


Reply With QuoteReply With Quote