Excel
 

Column A B C

C=A*B
If A*B<$200 C=$200

Is the above logic possible.

Thank you in advance for your help....MK

One way:

=MAX(200, A * B)

Format as currency.

In article ,
"MK" wrote:

Column A B C

C=A*B
If A*B<$200 C=$200

Is the above logic possible.

=IF(A*B<200,200,A*B)

--
tj


"MK" wrote:

Column A B C

C=A*B
If A*B<$200 C=$200

Is the above logic possible.

Thank you in advance for your help....MK