Thread: If/Then Formulas
View Single Post
  #2  
Old August 12th, 2008, 09:01 PM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
  
Posts: 8,419
Default 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.