How to round of to 2 figures

[40Nikond15]

="I have " &if( a1>=B1,"Gained","Lost)&(a1-b1)&"Pound(s) this month"

A1=143.3 B1=143

How do I get this to show a whole number(s) with 2 decimal places?

 

[Eric W]

Try:

Book1
	A	B	C
1	143.3	143	I have Gained .30 Pound(s) this month
Sheet5

Cell Formulas
Range	Formula
C1	C1	="I have " &IF( A1>=B1,"Gained ","Lost ")&TEXT(ABS(A1-B1),"#.00")&" Pound(s) this month"

 

[Habtest]

="I have " &IF(A1>=B1,"Gained ","Lost ")&TEXT(ABS(A1-B1),"0.00")&" Pound(s) this month"

 

[40Nikond15]

="I have " &IF(A1>=B1,"Gained ","Lost ")&TEXT(ABS(A1-B1),"0.00")&" Pound(s) this month"

Thanks, it works like a charm

 

[Habtest]

Great thank you very much

Glad we were able to help

 

[40Nikond15]

Try:

Book1
	A	B	C
1	143.3	143	I have Gained .30 Pound(s) this month
Sheet5

Cell Formulas
Range	Formula
C1	C1	="I have " &IF( A1>=B1,"Gained ","Lost ")&TEXT(ABS(A1-B1),"#.00")&" Pound(s) this month"

Thanks for the answere