Thread: "IF" formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default "IF" formula

As you are not very specific, try this:

=IF(F3predetermined_number, F3*greater_number, F3*$I$2)

Hope this helps.

Pete

On Nov 5, 6:26*pm, George wrote:
I have a formula in a cell =sum(F3*$I$2), I would like to add another formula
that changes I2 to a greater number if F3 is greater then a predetermined
number.