Thread: If/Then Formulas
View Single Post
  #5  
Old August 12th, 2008, 09:05 PM posted to microsoft.public.excel.worksheet.functions
Per Jessen
external usenet poster
  
Posts: 686
Default If/Then Formulas
Hi

=IF(F7=1,E7*1,IF(F7=2,E7*1,IF(F7=3,E7*2,"")))

Regards,
Per

"Bk Goto" skrev i meddelelsen
...
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.