DECIMAL PLACES IN FORMULAS

E

excllent 1

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
 
A

Arvi Laanemets

Hi

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


Arvi Laanemets
 
D

Duke Carey

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

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

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
 
Top