=if help

[james rockford]

Book1
	A	B	C	D	E
1	h	1	100	100	closed
2			ifb1=1d1
3			hitoall.ihaveawhatifstatementsetupandIwouldliketoaddtothissothatwhene1hasclosedincellthenc1willgoto0..helpandthanksforthehelp
Sheet1

 

[Seti]

I'm not sure the order of the conditions but here is one stab.

=IF(E1="closed",0,if(B1=1,D1,""))

 

[james rockford]

thanks seti...that works...question if i was to add one more item like if e1 = closed or d then do "0" how would you add that one???

and thanks for the help

 

[Seti]

I think this is what you mean:

=IF(OR(E1="closed",E1="d"),0,if(B1=1,D1,""))

but maybe you mean this:

=IF(OR(E1="closed",E1=D1),0,if(B1=1,D1,""))

 

[james rockford]

that work great thanks for your help..... ray:

 

[james rockford]

seti...just an up date this is working super maaaaannnnnn......again thanks for the tip my boss think i can change water into wine now......

ray: