On Mar 24, 5:40*pm, "Fred Smith" wrote:
And you don't need all the parentheses. And you should have something to say
what you want if none of the tests are true. If you're happy with 0 in this
case, use:

=IF(G17="","",IF(OR(G17=166718,G17=166719),1,IF(G1 7=16582,2,IF(G17=166685,4*,0))))

Regards,
Fred

"Mike H" wrote in message

...



Try it like this

=IF(G17=(166719),1, IF(G17=(165852),2, IF(G17=(165851),0,
IF(G17=(166718),1, IF(G17=(166685),4, IF(G17=(166745),0, IF(G17=(""),""
)))))))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Xiamen" wrote:

I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0",
IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0",
IF(G17=(""),""
)))))))

Now i want to add the result of this statement from consecutive rows.
i did sum on the results but i am not able to add the results of my
statements.

can you tell me how i can add the results of this statement?- Hide quoted text -

- Show quoted text -

I might consider controlling the cell with an Index/Match from a table.