"Teethless mama" wrote:
=MIN(1600, (C16+C17)*30%)

Should it be MAX?

ABS'ly. I mix up left and right, too. I even had written MAX initially,
but changed it to MIN at the last minute, ass-u-me-ing I had made the same
mistake and mis-rereading the OP's posting. D'oh!


----- original message -----

"Teethless mama" wrote in message
...
=MIN(1600, (C16+C17)*30%)

Should it be MAX?


"Joe User" wrote:


"dschneider3" wrote:
I'm trying to use the IF function to do the following:
IF(C16+C17)*.31600, (C16+C17)*.3, 1600.

=MIN(1600, (C16+C17)*30%)


----- original message -----

"dschneider3" wrote:
I'm trying to use the IF function to do the following:
IF(C16+C17)*.31600,
(C16+C17)*.3, 1600.

In English: If the sum of this range times 30% is greater than 1600
then
display the sum of this range times 30%, else display 1600.

I can't get this to work? Can anyone help me?