You are the best!! I knew XL could do it, but I am self taught, and never
had the need for such a formula.

THANK YOU THANK YOU THANK YOU!!!!
--
Bkg.


"Gary Brown" wrote:

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