Combining IF, OR, AND statements together

[lindsgray]

I'm trying to combine all 3 statements into one formula. My logic is, IF date = 2000 in cells H, I, J return $0. AND if Project Manager = Smith, return value in cell F2

Here is my IF and OR statement combined:

=IF(OR($H7=2000,0,OR($I7=2000,0,OR($J7=2000,0))),0,$F7)

Now I want to add in the following formula:

=IF(L7="Smith",$F7,0)

How can I combine the two?

Thank you!

[mcmahobt]

You have two separate conditions here. The first (OR statements, which could be condensed to =IF(OR(H7=2000,I7=2000,J7=2000),0,F7)) has zero as the true value and F7 as the false value. The second formula has this switched, with F7 as the true value, and zero as the false.

You could try something like this:

Please Login or Register  to view this content.

but if the first statement is returned false, and the second as well, this could produce an error since the first statement should have returned zero instead of F7.

[lindsgray]

This worked wonderfully! Thank you so much for the quick response and more simple formula. I really appreciate it!

[samba_ravi]

=IF(OR(H7=2000,I7=2000,J7=2000,L7<>"Smith"),0,F7)