Thread: "IF" formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George George is offline
external usenet poster
 
Posts: 347
Default "IF" formula

Thanks Pete, here is what I need;
I have one cell that has a square footage number in it, this number is then
multiplied by another number in a different cell. If the square footage
number goes over 16, I would like to multipy the square footage number by the
original number plus 1.35 more.

"Pete_UK" wrote:

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.