Thread
:
Excel
View Single Post
#
2
JE McGimpsey
Posts: n/a
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.
Reply With Quote