Thread: If/Then Formulas
View Single Post
  #4  
Old August 12th, 2008, 09:03 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
  
Posts: 1,245
Default 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"))