how to do nested IF formulas
 

I'm trying to create an if statment such that
if E1=a then 1
if E1=b then 2
if E1=c then 3
else all = 0

I've been trying the formula like so: if(E3=i,1,((E3=b,2),(E3=p,3,0))0)
I can't seem to get the formula to work. Can someone help me with this?

Thanks.

how to do nested IF formulas
 

Try this:

=SUM((E1={"a","b","c"})*{1,2,3})


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"BigTim" wrote:

I'm trying to create an if statment such that
if E1=a then 1
if E1=b then 2
if E1=c then 3
else all = 0

I've been trying the formula like so: if(E3=i,1,((E3=b,2),(E3=p,3,0))0)
I can't seem to get the formula to work. Can someone help me with this?

Thanks.

how to do nested IF formulas
 

=IF(E3="i",1,IF(E3="b",2,IF(E3="p",3,0)))

--
Allllen


"BigTim" wrote:

I'm trying to create an if statment such that
if E1=a then 1
if E1=b then 2
if E1=c then 3
else all = 0

I've been trying the formula like so: if(E3=i,1,((E3=b,2),(E3=p,3,0))0)
I can't seem to get the formula to work. Can someone help me with this?

Thanks.

how to do nested IF formulas
 

Wow, that works! Thanks.

"Ron Coderre" wrote:

Try this:

=SUM((E1={"a","b","c"})*{1,2,3})


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"BigTim" wrote:

I'm trying to create an if statment such that
if E1=a then 1
if E1=b then 2
if E1=c then 3
else all = 0

I've been trying the formula like so: if(E3=i,1,((E3=b,2),(E3=p,3,0))0)
I can't seem to get the formula to work. Can someone help me with this?

Thanks.

how to do nested IF formulas
 

I'm glad that worked for you....(thanks for letting me know)

***********
Regards,
Ron

XL2002, WinXP


"BigTim" wrote:

Wow, that works! Thanks.

"Ron Coderre" wrote:

Try this:

=SUM((E1={"a","b","c"})*{1,2,3})


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"BigTim" wrote:

I'm trying to create an if statment such that
if E1=a then 1
if E1=b then 2
if E1=c then 3
else all = 0

I've been trying the formula like so: if(E3=i,1,((E3=b,2),(E3=p,3,0))0)
I can't seem to get the formula to work. Can someone help me with this?

Thanks.

how to do nested IF formulas
 

One mo
=(e1="a")+2*(e1="b")+3*(e1="c")



BigTim wrote:

I'm trying to create an if statment such that
if E1=a then 1
if E1=b then 2
if E1=c then 3
else all = 0

I've been trying the formula like so: if(E3=i,1,((E3=b,2),(E3=p,3,0))0)
I can't seem to get the formula to work. Can someone help me with this?

Thanks.

--

Dave Peterson