JPP has brought this to us :
I have the following code:
=IF('CCI Info'!DR105=0.2&'CCI Info'!DR106=0.2&'CCI
Info'!DR107=0.2&'CCI Info'!DR108=0.2&'CCI Info'!DR109=0.2&'CCI
Info'!DR110=0.2&'CCI Info'!DR111=0.2&'CCI Info'!DR112=0.2, 'CCI
Info'!$DR$105&" "&'CCI Info'!$DR$106&" "&'CCI Info'!$DR$107&" "&'CCI
Info'!$DR$108&" "&'CCI Info'!$DR$109&" "&'CCI Info'!$DR$110&" "&'CCI
Info'!$DR$111&" "&'CCI Info'!$DR$112, )
And it works perfectly. But when I add line DR113 to the function, it
stops working. I have code similar to this in another part of the
worksheet, and it is MUCH longer. There is no reason this code shouldn't
work. I have used it before, and it worked until I added :
&'CCI Info'!DR113=0.2
&" "&'CCI Info'!$DR$113
After that I get a Division/0 error. Nothing changed, and this worked in
my other cell. What's up? Does Excel have a limit on data or something?
All I am trying to do is display multiple results in one cell!!
I don't see how this formula syntax can work at all! (I'm using US Eng
version) I suggest you remove all the ampersands, wrap the 'test'
portion in 'AND()', AND wrap the 'value if true' portion in
CONCATENATE()...
=IF(AND('CCI Info'!DR105=0.2,'CCI Info'!DR106=0.2,'CCI
Info'!DR107=0.2,'CCI Info'!DR108=0.2,'CCI Info'!DR109=0.2,'CCI
Info'!DR110=0.2,'CCI Info'!DR111=0.2,'CCI Info'!DR112=0.2,'CCI
Info'!DR113=0.2),CONCATENATE('CCI Info'!$DR$105," ",'CCI
Info'!$DR$106," ",'CCI Info'!$DR$107," ",'CCI Info'!$DR$108," ",'CCI
Info'!$DR$109," ",'CCI Info'!$DR$110," ",'CCI Info'!$DR$111," ",'CCI
Info'!$DR$112," ",'CCI Info'!DR113),)
-OR-
=IF(COUNTIF('CCI Info'!DR105:'CCI Info'!DR113,"=0.2")=COUNTA('CCI
Info'!DR105:'CCI Info'!DR113),CONCATENATE('CCI Info'!$DR$105," ",'CCI
Info'!$DR$106," ",'CCI Info'!$DR$107," ",'CCI Info'!$DR$108," ",'CCI
Info'!$DR$109," ",'CCI Info'!$DR$110," ",'CCI Info'!$DR$111," ",'CCI
Info'!$DR$112," ",'CCI Info'!DR113),)
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion