IF And OR help???

[wisemank]

Hello to all,
I would like to convert data from a numerical value or values to a text value or string.

Column A are the X axis numbers, Column B is Y axis values and column C are the Z axis values. Based on the value I want to declare it as the Axis(s).

The values in all columns are predictable and always a value of either 0.0, .50 or 1.0. So I am looking to convert the following examples:

A B C D

0.50 1.00 0.00 "XY"
0.50 1.00 0.00 "XY"
0.00 1.00 0.50 "YZ"
0.00 1.00 0.00 "Y"
0.00 1.00 0.00 "Y"
0.50 1.00 0.50 "XYZ"
0.00 1.00 0.00 "Y"

I looked to do an "IF(And" statement, but it was around 9 conditions or so...Any ideas for a better way?

Thanks in advanced

 

[63falcondude]

Hello, the best that I came up with is to add three columns between C and D.
Cell D1 =IF(A1>0,"X","")
Cell E1 =IF(B1>0,"Y","")
Cell F1 =IF(C1>0,"Z","")
Cell G1 =D1&E1&F1

 

[JoeMo]

Copy D1 down.

Excel Workbook
	A	B	C	D
1	0.5	1	0	XY
2	0.5	1	0	XY
3	0	1	0.5	YZ
4	0	1	0	Y
5	0	1	0	Y
6	0.5	1	0.5	XYZ
7	0	1	0	Y
Sheet6