Thread: Excel
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.