04-10-2010, 04:29 AM
I'm trying to formula this:
If C12 contains "* Close" or "* Short", then Q12 = 7. If C12 contains neither, then Q12 is zero (or no entry).
I tried below, but the results are wrong, though the formula seems syntaxed (I know, not a word, but you know what I mean, eh?) correctly.
IF(OR(C12="* Close",C12="* Short"),7,0)
I tried at Mr Excel, but I don't understand the suggestion.
If C12 contains "* Close" or "* Short", then Q12 = 7. If C12 contains neither, then Q12 is zero (or no entry).
I tried below, but the results are wrong, though the formula seems syntaxed (I know, not a word, but you know what I mean, eh?) correctly.
IF(OR(C12="* Close",C12="* Short"),7,0)
I tried at Mr Excel, but I don't understand the suggestion.
“Art is how we decorate space.
Music is how we decorate time.”
Jean-Michel Basquiat
Music is how we decorate time.”
Jean-Michel Basquiat