krcraeanna
New Member
- Joined
- Sep 6, 2006
- Messages
- 2
I have a question. Is it possible to combine multiple conditions ( AND & OR) in an IF statement in one formula?
Example:
=IF(AND(B3 > 0,C3 > 0,D3 >0,E3=0), D3, 0), IF(OR(C3 is NULL), D3, 0)
I want to say:
If (B3 > 0 and C3 > 0 and D3 >0 and E3=0) OR (C3 is NULL)
then
value of cell D3
else
0
end if.
I get a #NAME? error in the cell.
Thanks in advance for any ideas.
Example:
=IF(AND(B3 > 0,C3 > 0,D3 >0,E3=0), D3, 0), IF(OR(C3 is NULL), D3, 0)
I want to say:
If (B3 > 0 and C3 > 0 and D3 >0 and E3=0) OR (C3 is NULL)
then
value of cell D3
else
0
end if.
I get a #NAME? error in the cell.
Thanks in advance for any ideas.