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 <atyahoo<dotcom
----
"MK" wrote in message
...
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
|