DECIMAL PLACES IN FORMULAS

[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

 

[N Harkawat]

=IF(K10>0,"C "&round(K10,2),"F "&round(K10,2))

 

[JE McGimpsey]

One way:

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

 

[Arvi Laanemets]

Hi

=IF(K10>0,"C " & TEXT(K10,"#.00"),"F " & TEXT(K10,"#.00"))


Arvi Laanemets

 

[Guest]

Slightly shorter version - no more functional, but easier to read:

=IF(K10>0,"C ","F ") & TEXT(K10,"#.00")

 

[Bernie Deitrick]

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