Excel

MK · Jun 17, 2005

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

JE McGimpsey · Jun 17, 2005

One way:

=MAX(200, A * B)

Format as currency.

tjtjjtjt · Jun 17, 2005

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