Dang quotation marks
I was able to add quotation marks to the formula and was able to make it work.
Right(
"MyString
",Len(
"MyString
")-6)
Thanks,
How about this one. I want to do add up the values of If-Then statements. Something like this.
If "[Connector1]" = "No" Then
RESULT = 0
Else
RESULT = 1
End If
+
If "[Connector2]" = "No" Then
RESULT = 0
Else
RESULT = 1
End If
What's wrong with this picture? Both If-then statements work independently but I can't get them to add. I even tried to add CInt in front of each If-Then statement with no success.