Thread: IF formula is greater than X use it, if not use X
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
  
Posts: 905
Default IF formula is greater than X use it, if not use X

"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?
Reply With QuoteReply With Quote