trying to post a formula- does not work

[etaf]

i'm trying to post a formula and it keeps getting parts truncated

i have used excel jeanie and that also truncated
here
http://www.mrexcel.com/forum/excel-questions/710151-if-statement-excel-2007-a-2.html#post3506708

and also tried to post in the forum

used

tags

code
noparse
formula

nothing seems to work and i

so i have taken an image and posted on a share

its here

Formula.JPG

I have tried removing all spaces .. breaking the formula into separate lines and posting
makes no difference


thanks
Wayne

 

[kajero]

see the sticky topic

 

[Smitty]

< & > signs don't take all that well as the board software sees them as HTML and tries to render them as such.

If you put spaces before and after the < & > signs you should be able to paste ok.

HTH,

 

[etaf]

Thanks - I will try that here - spaces between all ( and < and > and ,

= IF ( OR ( AND ( C6 < A6 , C6 < B6 ) , C6 < A6 , C6 < B6 ) , 1 , IF ( OR ( AND ( C6 = A6 , C6 = B6 ) , AND ( C6 = A6, C6 > B6 ) , AND ( C6 > A6, C6 = B6 ) ) , 0 , IF ( AND ( C6 > A6, C6 > B6 ) , -1 , "does not meet conditions" ) ) )

EDIT


Excellent that worked - thanks

 

[Peter_SSs]

.. but I don't think you need to go to that much trouble. I think you'll find the problem is only "<" signs (not ">") and only if they are followed by a letter (not number or other symbol like <=).

You have 4 symbols that meet those criteria so I think you would only need 4 spaces.

Refer also this thread.

 

[etaf]

brilliant - thanks for that , very clear now why an issue