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
|