If/Then Formulas
Yet another method...
=E7*LOOKUP(F7,{1,2,3},{1,1,2})
Rick
"Bk Goto" wrote in message
...
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.
|