Excel Question

MK · Jun 18, 2005

Column A B C
C=A*B
If A*B<S200 C=$200
If A or B = 0, C=0

How to copy Sentence to another cell

Thanks in advance for your help......MK

Max · Jun 18, 2005

Not sure, but think you could try
putting in C1, and copy down:
=IF(OR(A1=0,B1=0),0,MAX(A1*B1,200))