How do I combine an If and And Statement to solve the following;
If I have two elements looking for a product:
A1 B1 C1
500 .20 100
If A1 <>0 and B1=0, then C=A1
If A1 = 0 then C= A1
If A1 <>0 and B1<>0, then C1=A1*B1
What is the Fx?