If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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")) |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
If/Then Formulas
And even shorter yetg...
=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 |
Thread Tools | |
Display Modes | |
|
|