DECIMAL PLACES IN FORMULAS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

this is the formula i am using. =IF(K10>0,"C "&K10,"F "&K10). when the
results are computed i get from 2 to more than 10 decimals places. I have
tried all the typical decimal amounts but can not fix this. I only want two
decimal places shown with round off. Any help appreciated.
Bill
 
Slightly shorter version - no more functional, but easier to read:

=IF(K10>0,"C ","F ") & TEXT(K10,"#.00")
 
It seems that you are using letters to indicate Pos/Neg, so perhaps:

=IF(K10>0,"C ","F ")&TEXT(ABS(K10),"0.00")

HTH,
Bernie
MS Excel MVP
 
Back
Top