Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" formula
Well then, try this:
=IF(F316, F3*$I$2*1.35, F3*$I$2) using the same cell references as before. Hope this helps. Pete On Nov 6, 12:43*pm, George wrote: 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.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" formula
Thanks again Pete, it's close, but I don't want to multiply by the 1.35, I
want to add the 1.35 to the existing number. The existing number is 4.75, if the square footage is over 16 I want the new multiplier to be 6.10, (4.75 + 1.35) but if the square footage is under 16 I need the multiplier to remain at 4.75 "Pete_UK" wrote: Well then, try this: =IF(F316, F3*$I$2*1.35, F3*$I$2) using the same cell references as before. Hope this helps. Pete On Nov 6, 12:43 pm, George wrote: 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.- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" formula
Okay, I think this is what you want:
=IF(F316, F3*($I$2 + 1.35), F3*$I$2) Hope ths helps. Pete On Nov 6, 1:07*pm, George wrote: Thanks again Pete, it's close, but I don't want to multiply by the 1.35, I want to add the 1.35 to the existing number. *The existing number is 4.75, if the square footage is over 16 I want the new multiplier to be 6.10, (4.75 + 1.35) but if the square footage is under 16 I need the multiplier to remain at 4.75 "Pete_UK" wrote: Well then, try this: =IF(F316, F3*$I$2*1.35, F3*$I$2) using the same cell references as before. Hope this helps. Pete On Nov 6, 12:43 pm, George wrote: 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.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" formula
Or, ...
=F3*($I$2+1.35*(F316)) -- ** John C ** "Pete_UK" wrote: Okay, I think this is what you want: =IF(F316, F3*($I$2 + 1.35), F3*$I$2) Hope ths helps. Pete On Nov 6, 1:07 pm, George wrote: Thanks again Pete, it's close, but I don't want to multiply by the 1.35, I want to add the 1.35 to the existing number. The existing number is 4.75, if the square footage is over 16 I want the new multiplier to be 6.10, (4.75 + 1.35) but if the square footage is under 16 I need the multiplier to remain at 4.75 "Pete_UK" wrote: Well then, try this: =IF(F316, F3*$I$2*1.35, F3*$I$2) using the same cell references as before. Hope this helps. Pete On Nov 6, 12:43 pm, George wrote: 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.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |