Formula outputting incorrectly?

[kpark91]

Hi, I've tried to post a formula in Excel Questions forum (without the spaces)

=SUMPRODUCT((M2:M10 < NOW()) * (M2:M10 <> "") * (N2:N10 <> "Completed"))

but it displayed as a totally different formula.

Any reason why?

 

[Joe4]

See here: http://www.mrexcel.com/forum/showthread.php?t=96334

 

[kpark91]

Ah I c. thank you~

 

[Peter_SSs]

Using code tags often does not solve that problem any more, but inserting a space after the < or > should (Should be no need for a space before the < or >).

 

[Joe4]

Using code tags often does not solve that problem any more

Works for me about 99% of the time. I think I can only recall once that it didn't.

 

[Peter_SSs]

Works for me about 99% of the time. I think I can only recall once that it didn't.

I definitely don't have as good a success rate as that. Perhaps I don't hold my mouth correctly when posting.

 

[Joe4]

I wonder if it has anything to do with individual profile settings.
Not sure, I don't really mess around with mine...

 

[Peter_SSs]

My last post may have been misleading.

The majority of times I post a formula with < and no following space, the formula dispalys correctly anyway. However, if it doesn't then using code tags also doesn't seem to usually help. So the code tags success rate for me is poor if the standard method didn't work. If the standard method worked, my success rate with code tags is either 0% or 100% because I don't use code tags then.

In terms of why a formula would sometimes display correcly and sometimes not, schielrn made some interestion observations in post #17 of this thread.

 

[kpark91]

Hi there has been another occasion where the code was 'broken' when posted.
I'm guessing it has to do with the forum XML or whatever they're using.

Take a look:
http://www.mrexcel.com/forum/showthread.php?t=570660&page=4

I've tried posting

Option Base 0
Option Explicit
Sub GetCIK()
    Dim X As Long, LastRow1 As Long, OutputRow1 As Long, CellContent As String, LastRow&
    Dim pos1&, pos2&, OutputRow2&
    
    Const StartRow As Long = 1
    Const DataCol As String = "A"
    Const OutputSheet As String = "URLs"
    Const OutputCol1 As String = "B"
    Const OutputCol2 As String = "C"
    
    LastRow = Sheets("wquery").Cells(Rows.Count, DataCol).End(xlUp).Row
    OutputRow1 = Worksheets(OutputSheet).Cells(Rows.Count, OutputCol1).End(xlUp).Row
    OutputRow2 = Worksheets(OutputSheet).Cells(Rows.Count, OutputCol2).End(xlUp).Row
    
    For X = StartRow To LastRow
        If Sheets("wquery").Cells(X, DataCol).Value Like "*getcompany*CIK*" Then
          OutputRow1 = OutputRow1 + 1
          CellContent = Sheets("wquery").Cells(X, DataCol).Value
          Worksheets(OutputSheet).Cells(OutputRow1, OutputCol1).Value = Left$(Split(CellContent, ";")(1), 14)
        End If
        
        If Sheets("wquery").Cells(X, DataCol).Value Like "*""nowrap*</td>" Then
            OutputRow2 = OutputRow2 + 1
            CellContent = Sheets("wquery").Cells(X, DataCol).Value
            pos1 = InStr(1, CellContent, """nowrap""")
            pos2 = InStr(1, CellContent, "</td>")
            Worksheets(OutputSheet).Cells(OutputRow2, OutputCol2).Value = Mid(CellContent, pos1 + 9, pos2 - pos1 - 9)
        End If
    Next X
    
End Sub

Using code tags often does not solve that problem any more, but inserting a space after the < or > should (Should be no need for a space before the < or >).

It seems like Peter was right xD but in my case, I could not use spaces.. except I could concatenate the strings with ;amp (&).