If/And Formula

[Hamed parhizkar]

If I have 4 cells,

A1=10
B1=0
C1=10
D1=15

I know the first part of the formula of what I am trying to do.

=if(sum(c1:d1)<>0,"A","")

But how do I also say in the same formula that if B1<>0 and
if(sum(c1:d1)<>0,"A","")

So if B1=0 then I dont want the "A" to pop up.

 

[akphidelt]

This really isn't a programming question but to do what you ask you can try

If(And(B1<>0,sum(c1:d1)<>0),"A","")

 

[dan dungan]

I put the following formula in cell A4.

=IF(AND(B1<>0,SUM(C11)<>0),"A","")

Is that what you wanted?

 

[sbitaxi]

If I have 4 cells,

A1=10
B1=0
C1=10
D1=15

I know the first part of the formula of what I am trying to do.

=if(sum(c1:d1)<>0,"A","")

But how do I also say in the same formula that if B1<>0 and
if(sum(c1:d1)<>0,"A","")

So if B1=0 then I dont want the "A" to pop up.

=IF(B1<>0,IF(SUM(C11)<>0,"A",""),"")

That will check B1 first, if the result is True, then it moves on to
the next IF statement, if it is false, then the result is "".


Steven