Combining IF, OR and And formula to return a value

[MrPink1986]

Hi

I have a spread sheet that if column I has a value of "manual" or "committee" and column P does not equal 0 to return the text "Investigate".

Am I right in thinking I need to combine the IF, And, OR function in to 1 formula? If so I would appreacite some help, if there is a better way of doing this that too would be great.

Thanks
Stephen

 

[kevatarvind]

hi try below

=IF(AND(OR(I1="manual",I1="committee"),P1<>0),"Investigate","")

 

[MrPink1986]

Hi thanks that worked perfectly. Thanks again.