Decimal places in an if statement

[remin1100]

Hello, I am new to the forum and have an issue with the number of decimal places returned in an if statement. My formula is :
=IF(C24>0,"X"&C24&"Y"&D24,0)
C and D are both rounded to 4 decimal places.
C24 = 2.0000
D24=1.0000

The return value I get is

X2Y1

I need to have it return a value with at least 4 decimal places after both the 2 and the 1.

Any help is greatly appreciated.

 

[jmacleary]

Try this:

Book1
	C	D	E	F
24	2	1		X2.0000Y1.0000
25	2.5	1		X2.5000Y1.0000
26	3	1.87654		X3.0000Y1.8765
Sheet4

Cell Formulas
Range	Formula
F24:F26	F24	=IF(C24>0,"X"&TEXT(C24,"0.0000")&"Y"&TEXT(D24,"0.0000"),0)

 

[mole999]

Try =IF(C24>0,"X"&TEXT(C24,"0.0000")&"Y"&TEXT(D24,"0.0000"),0)

 

[remin1100]

Worked like a charm, THANK YOU!

 

[jmacleary]

You're welcome and thanks for the feedback.