View Single Post
  #3  
Old August 12th, 2008, 09:02 PM posted to microsoft.public.excel.worksheet.functions
Gary Brown[_4_]
external usenet poster
 
Posts: 166
Default If/Then Formulas

=IF(OR(F7=1,F7=2),E7*1,E7*2)
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"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.