I have a Excel XP spreadsheet that have multiple IF,AND,OR
statements in one cell.
I have no problem with just one statement but not with two
or more. The values are there but not the custom format as
set up in the cell.
Any ideas??
Thanks

Give data and formulae details.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marty" wrote in message
...
I have a Excel XP spreadsheet that have multiple IF,AND,OR
statements in one cell.
I have no problem with just one statement but not with two
or more. The values are there but not the custom format as
set up in the cell.
Any ideas??
Thanks

Sample #1 below would be a typical equation set up in a
cell (some equations may be extremely long and may span
several cells. However, in this particular case the answer
as defined by MSPQUAN or MSPQUAN*2 should be say 12 PR or
in some cases values such as 1.5 PR, or 17.5 PR.
Even if the custom format in the cell is set up as ###/##
P\R the only thing displayed is say 12 or 1.5 or 17.5. If I
limit the equation to one equation as in sample #2 the
display will read correctly.

Any ideas on how to solve this???

Thanks in advance.

Sample #1
=IF(MSPH1="None","","")&IF(MSPH1="2 Pr Std
Butt",MSPQUAN,IF(MSPH1="3 Pr Std
Butt",MSPQUAN*1.5,IF(MSPH1="4 Pr Std
Butt",MSPQUAN*2,"")))&IF(AND(MSPH1="HD OFFSET PIVOT SET",
OR(MSPDH="HRSO",MSPDH="HLSI",MSPDH="HLSO",MSPDH="H RSI"),OR(MSPCLOS1="DOM
SC60 NHO", MSPCLOS1="DOM SC60 HO",MSPCLOS1="DOM SC61 NHO",
MSPCLOS1="LCN SC61 HO",MSPCLOS1="LCN 1371 NHO",
MSPCLOS1="LCN 1371 HO",MSPCLOS1="LCN 4041 NHO",
MSPCLOS1="LCN 4041 HO", MSPCLOS1="LCN 2031",MSPCLOS1="LCN
2033",MSPCLOS1="LCN 2033")),MSPQUAN,"")&IF(MSPH1="2 Pr .134
Butt B/O",MSPQUAN,IF(MSPH1="3 Pr .134 Butt
B/O",MSPQUAN*1.5,IF(MSPH1="4 Pr .134 Butt
B/O",MSPQUAN*2,"")))&IF(MSPH1="2 Pr .180 Butt
B/O",MSPQUAN,IF(MSPH1="3 Pr .180 Butt
B/O",MSPQUAN*1.5,IF(MSPH1="4 Pr .180 Butt B/O",MSPQUAN*2,"")))

Sample #2
=IF(MSPH1="None","","")&IF(MSPH1="2 Pr Std
Butt",MSPQUAN,IF(MSPH1="3 Pr Std
Butt",MSPQUAN*1.5,IF(MSPH1="4 Pr Std Butt",MSPQUAN*2,"")))

-----Original Message-----
Give data and formulae details.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marty" wrote in message
...
I have a Excel XP spreadsheet that have multiple IF,AND,OR
statements in one cell.
I have no problem with just one statement but not with two
or more. The values are there but not the custom format as
set up in the cell.
Any ideas??
Thanks


.

I just goofed:
In Sample #2 I had two statements which won't work.
Sample #2 should have read:
IF(MSPH1="2 Pr Std Butt",MSPQUAN,IF(MSPH1="3 Pr Std
Butt",MSPQUAN*1.5,IF(MSPH1="4 Pr Std Butt",MSPQUAN*2,"")))


This is the only way it works!

"Marty" wrote:

Sample #1 below would be a typical equation set up in a
cell (some equations may be extremely long and may span
several cells. However, in this particular case the answer
as defined by MSPQUAN or MSPQUAN*2 should be say 12 PR or
in some cases values such as 1.5 PR, or 17.5 PR.
Even if the custom format in the cell is set up as ###/##
P\R the only thing displayed is say 12 or 1.5 or 17.5. If I
limit the equation to one equation as in sample #2 the
display will read correctly.

Any ideas on how to solve this???

Thanks in advance.

Sample #1
=IF(MSPH1="None","","")&IF(MSPH1="2 Pr Std
Butt",MSPQUAN,IF(MSPH1="3 Pr Std
Butt",MSPQUAN*1.5,IF(MSPH1="4 Pr Std
Butt",MSPQUAN*2,"")))&IF(AND(MSPH1="HD OFFSET PIVOT SET",
OR(MSPDH="HRSO",MSPDH="HLSI",MSPDH="HLSO",MSPDH="H RSI"),OR(MSPCLOS1="DOM
SC60 NHO", MSPCLOS1="DOM SC60 HO",MSPCLOS1="DOM SC61 NHO",
MSPCLOS1="LCN SC61 HO",MSPCLOS1="LCN 1371 NHO",
MSPCLOS1="LCN 1371 HO",MSPCLOS1="LCN 4041 NHO",
MSPCLOS1="LCN 4041 HO", MSPCLOS1="LCN 2031",MSPCLOS1="LCN
2033",MSPCLOS1="LCN 2033")),MSPQUAN,"")&IF(MSPH1="2 Pr .134
Butt B/O",MSPQUAN,IF(MSPH1="3 Pr .134 Butt
B/O",MSPQUAN*1.5,IF(MSPH1="4 Pr .134 Butt
B/O",MSPQUAN*2,"")))&IF(MSPH1="2 Pr .180 Butt
B/O",MSPQUAN,IF(MSPH1="3 Pr .180 Butt
B/O",MSPQUAN*1.5,IF(MSPH1="4 Pr .180 Butt B/O",MSPQUAN*2,"")))

Sample #2
=IF(MSPH1="None","","")&IF(MSPH1="2 Pr Std
Butt",MSPQUAN,IF(MSPH1="3 Pr Std
Butt",MSPQUAN*1.5,IF(MSPH1="4 Pr Std Butt",MSPQUAN*2,"")))

-----Original Message-----
Give data and formulae details.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marty" wrote in message
...
I have a Excel XP spreadsheet that have multiple IF,AND,OR
statements in one cell.
I have no problem with just one statement but not with two
or more. The values are there but not the custom format as
set up in the cell.
Any ideas??
Thanks


.