| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If/Then Formulas
Hello and Good Day =)
I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
How about without an if formula
=CHOOSE(F7,E7*1,E7*1,E7*2) Mike "Bk Goto" wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
=IF(OR(F7=1,F7=2),E7*1,E7*2)
-- Hope this helps. Thanks in advance for your feedback. Gary Brown "Bk Goto" wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
You are the best!! I knew XL could do it, but I am self taught, and never
had the need for such a formula. THANK YOU THANK YOU THANK YOU!!!! -- Bkg. "Gary Brown" wrote: =IF(OR(F7=1,F7=2),E7*1,E7*2) -- Hope this helps. Thanks in advance for your feedback. Gary Brown "Bk Goto" wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
Bk Goto wrote:
Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. =IF(OR(F7=1,F7=2),E7,IF(F7=3,E7*2,"F7 is not 1, 2 or 3")) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
Hi
=IF(F7=1,E7*1,IF(F7=2,E7*1,IF(F7=3,E7*2,""))) Regards, Per "Bk Goto" skrev i meddelelsen ... Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
Yet another method...
=E7*LOOKUP(F7,{1,2,3},{1,1,2}) Rick "Bk Goto" wrote in message ... Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
On Tue, 12 Aug 2008 12:56:28 -0700, Bk Goto
wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. Just to add another formula to the collection you have already got: =E7*(4-3*F7+F7*F7)/2 Shortest so far I guess, but also the least recommended to use because it is difficult to see through and hard to update when the requirements change. Lars-Åke |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
On Tue, 12 Aug 2008 20:45:35 GMT, Lars-Åke Aspelin
wrote: On Tue, 12 Aug 2008 12:56:28 -0700, Bk Goto wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. Just to add another formula to the collection you have already got: =E7*(4-3*F7+F7*F7)/2 Shortest so far I guess, but also the least recommended to use because it is difficult to see through and hard to update when the requirements change. Lars-Åke Even shorter :-) =E7*(4-3*F7+F7^2)/2 Lars-Åke |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
And even shorter yet<g...
=E7*(1+INT(F7/3)) Rick "Lars-Åke Aspelin" wrote in message ... On Tue, 12 Aug 2008 20:45:35 GMT, Lars-Åke Aspelin wrote: On Tue, 12 Aug 2008 12:56:28 -0700, Bk Goto wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. Just to add another formula to the collection you have already got: =E7*(4-3*F7+F7*F7)/2 Shortest so far I guess, but also the least recommended to use because it is difficult to see through and hard to update when the requirements change. Lars-Åke Even shorter :-) =E7*(4-3*F7+F7^2)/2 Lars-Åke |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
And even shorter than that...
=E7*INT(1+F7/3) Rick "Rick Rothstein (MVP - VB)" wrote in message ... And even shorter yet<g... =E7*(1+INT(F7/3)) Rick "Lars-Åke Aspelin" wrote in message ... On Tue, 12 Aug 2008 20:45:35 GMT, Lars-Åke Aspelin wrote: On Tue, 12 Aug 2008 12:56:28 -0700, Bk Goto wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. Just to add another formula to the collection you have already got: =E7*(4-3*F7+F7*F7)/2 Shortest so far I guess, but also the least recommended to use because it is difficult to see through and hard to update when the requirements change. Lars-Åke Even shorter :-) =E7*(4-3*F7+F7^2)/2 Lars-Åke |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
I think we have a winner
"Rick Rothstein (MVP - VB)" wrote: And even shorter yet<g... =E7*(1+INT(F7/3)) Rick "Lars-Ã…ke Aspelin" wrote in message ... On Tue, 12 Aug 2008 20:45:35 GMT, Lars-Ã…ke Aspelin wrote: On Tue, 12 Aug 2008 12:56:28 -0700, Bk Goto wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. Just to add another formula to the collection you have already got: =E7*(4-3*F7+F7*F7)/2 Shortest so far I guess, but also the least recommended to use because it is difficult to see through and hard to update when the requirements change. Lars-Ã…ke Even shorter :-) =E7*(4-3*F7+F7^2)/2 Lars-Ã…ke |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
Think again...This one even shorter than Rick.R
=((F7=3)+1)*E7 "Mike H" wrote: I think we have a winner "Rick Rothstein (MVP - VB)" wrote: And even shorter yet<g... =E7*(1+INT(F7/3)) Rick "Lars-Ã…ke Aspelin" wrote in message ... On Tue, 12 Aug 2008 20:45:35 GMT, Lars-Ã…ke Aspelin wrote: On Tue, 12 Aug 2008 12:56:28 -0700, Bk Goto wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. Just to add another formula to the collection you have already got: =E7*(4-3*F7+F7*F7)/2 Shortest so far I guess, but also the least recommended to use because it is difficult to see through and hard to update when the requirements change. Lars-Ã…ke Even shorter :-) =E7*(4-3*F7+F7^2)/2 Lars-Ã…ke |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then Formulas
I suspect the OP didn't want to broaden his/her horizons beyond IF
=E7*(4-3*F7+F7^2)/2 Nice ;) Mike "Lars-Ã…ke Aspelin" wrote: On Tue, 12 Aug 2008 20:45:35 GMT, Lars-Ã…ke Aspelin wrote: On Tue, 12 Aug 2008 12:56:28 -0700, Bk Goto wrote: Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any help would be appreciated, I know it can be done, but haven't a clue as to how ;-) Thanx ~ Bkg. Just to add another formula to the collection you have already got: =E7*(4-3*F7+F7*F7)/2 Shortest so far I guess, but also the least recommended to use because it is difficult to see through and hard to update when the requirements change. Lars-Ã…ke Even shorter :-) =E7*(4-3*F7+F7^2)/2 Lars-Ã…ke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Hybrid Mode
