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 |
#21
|
|||
|
|||
If/Then Formulas
=E7*(F7=3)+E7*(OR(F7={1,2,3}))
-- John C "John C" wrote: And of course, stealing from Ricks' formula: =E7*(F7=3)+E7*(F7={1,2,3}) -- John C "Rick Rothstein (MVP - VB)" wrote: Of course, it is only shorter as long as the Column E address is an address composed of 2 characters (in the range A1:Z9). If the address is 3 characters long, then the formulas are the same length; and, if the address is 4 or more characters long, then your form of the formula will be shorter. Rick "Rick Rothstein (MVP - VB)" wrote in message ... LOL... you are going to kick yourself for missing this! One character shorter... =E7*(F7=3)+E7 Rick "Teethless mama" wrote in message ... 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 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 |
#22
|
|||
|
|||
If/Then Formulas
A little shorterg....
=E7*MID("0112",F7+1,1) Rick "John C" johnc@stateofdenial wrote in message ... =E7*(F7=3)+E7*(OR(F7={1,2,3})) -- John C "John C" wrote: And of course, stealing from Ricks' formula: =E7*(F7=3)+E7*(F7={1,2,3}) -- John C "Rick Rothstein (MVP - VB)" wrote: Of course, it is only shorter as long as the Column E address is an address composed of 2 characters (in the range A1:Z9). If the address is 3 characters long, then the formulas are the same length; and, if the address is 4 or more characters long, then your form of the formula will be shorter. Rick "Rick Rothstein (MVP - VB)" wrote in message ... LOL... you are going to kick yourself for missing this! One character shorter... =E7*(F7=3)+E7 Rick "Teethless mama" wrote in message ... 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 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 |
#23
|
|||
|
|||
If/Then Formulas
Nope, let's go back to Teethless mama's original form and modify it....
=((F7=3)+(F7""))*E7 There... one character shorter. g Rick "Rick Rothstein (MVP - VB)" wrote in message ... A little shorterg.... =E7*MID("0112",F7+1,1) Rick "John C" johnc@stateofdenial wrote in message ... =E7*(F7=3)+E7*(OR(F7={1,2,3})) -- John C "John C" wrote: And of course, stealing from Ricks' formula: =E7*(F7=3)+E7*(F7={1,2,3}) -- John C "Rick Rothstein (MVP - VB)" wrote: Of course, it is only shorter as long as the Column E address is an address composed of 2 characters (in the range A1:Z9). If the address is 3 characters long, then the formulas are the same length; and, if the address is 4 or more characters long, then your form of the formula will be shorter. Rick "Rick Rothstein (MVP - VB)" wrote in message ... LOL... you are going to kick yourself for missing this! One character shorter... =E7*(F7=3)+E7 Rick "Teethless mama" wrote in message ... 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 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 |
#24
|
|||
|
|||
If/Then Formulas
Again, assuming DV, even shorter
=E7*INT((F7+1)/2) -- John C "Rick Rothstein (MVP - VB)" wrote: A little shorterg.... =E7*MID("0112",F7+1,1) Rick "John C" johnc@stateofdenial wrote in message ... =E7*(F7=3)+E7*(OR(F7={1,2,3})) -- John C "John C" wrote: And of course, stealing from Ricks' formula: =E7*(F7=3)+E7*(F7={1,2,3}) -- John C "Rick Rothstein (MVP - VB)" wrote: Of course, it is only shorter as long as the Column E address is an address composed of 2 characters (in the range A1:Z9). If the address is 3 characters long, then the formulas are the same length; and, if the address is 4 or more characters long, then your form of the formula will be shorter. Rick "Rick Rothstein (MVP - VB)" wrote in message ... LOL... you are going to kick yourself for missing this! One character shorter... =E7*(F7=3)+E7 Rick "Teethless mama" wrote in message ... 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 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 |
#25
|
|||
|
|||
If/Then Formulas
=E7*INT(1+F7/3)
Several skipped postings Again, assuming DV, even shorter =E7*INT((F7+1)/2) Very nice! LOL... I almost had that formula originally (I just needed to think about it a "short" time moreg). Rick |
#26
|
|||
|
|||
If/Then Formulas
Someone just tapped me on the shoulder, it was a veterinarian, he told me to
step take my club and step away from the horse, as he is well and truly dead. -- John C "Rick Rothstein (MVP - VB)" wrote: =E7*INT(1+F7/3) Several skipped postings Again, assuming DV, even shorter =E7*INT((F7+1)/2) Very nice! LOL... I almost had that formula originally (I just needed to think about it a "short" time moreg). Rick |
#27
|
|||
|
|||
If/Then Formulas
On Wed, 13 Aug 2008 10:38:27 -0400, "Rick Rothstein \(MVP - VB\)"
wrote: =E7*INT(1+F7/3) Several skipped postings Again, assuming DV, even shorter =E7*INT((F7+1)/2) Very nice! LOL... I almost had that formula originally (I just needed to think about it a "short" time moreg). Rick Here is an even shorter =E7*INT(F7^.7) Lars-Åke |
#28
|
|||
|
|||
If/Then Formulas
1 less character...
=EVEN(H7)/2*G7 -- John C "Lars-Ã…ke Aspelin" wrote: On Wed, 13 Aug 2008 10:38:27 -0400, "Rick Rothstein \(MVP - VB\)" wrote: =E7*INT(1+F7/3) Several skipped postings Again, assuming DV, even shorter =E7*INT((F7+1)/2) Very nice! LOL... I almost had that formula originally (I just needed to think about it a "short" time moreg). Rick Here is an even shorter =E7*INT(F7^.7) Lars-Ã…ke |
#29
|
|||
|
|||
If/Then Formulas
Here is an even shorter
=E7*INT(F7^.7) Bravo!!! It is hard to imagine that a shorter one will be found. Rick |
#30
|
|||
|
|||
If/Then Formulas
Here is an even shorter
=E7*INT(F7^.7) Bravo!!! It is hard to imagine that a shorter one will be found. 1 less character... =EVEN(F7)/2*E7 LOL... I stand corrected. Excellent! Rick |
Thread Tools | |
Display Modes | |
|
|