Excel Question

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

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"MK" <MK@discussions.microsoft.com> wrote in message
news:077158D2-666F-45A0-A80A-C5C9846323CB@microsoft.com...
> 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