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