Thread: IF formula is greater than X use it, if not use X
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
  
Posts: 694
Default IF formula is greater than X use it, if not use X
Hi
Maybe something like this =IF(C16+C17*130%1600,C16+C17*130%,1600)
HTH
John
"dschneider3" wrote in message
...
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