need help with formula

[Mike]

This is the formula im using & i want it to read a zero value if these cells
are blank or read zero, The only cells that have values is D Column & this
formula is in F6 WHY WON,T THIS WORK



=IF(L6>0,(D6*D$1),IF(R6>0,(D6*D$1),IF(X6>0,(D6*D$1),0)))

 

[Ms-Exl-Learner]

I am not clear what you are looking to do.

If you want to multiply D6 cell with D1 cell if L6 cell is grater than 0 Or
R6>0 Or X6>0 then use this below formula.
=IF(OR(L6>0,R6>0,X6>0),D6*D$1,0)

If you want to multiply D6 cell with D1 cell if all the cells like L6,R6 &
X6 is greater than zero then use the below formula.
=IF(AND(L6>0,R6>0,X6>0),D6*D$1,0)

Remember to Click Yes, if this post helps!

 

[Karto]

Mike -
could you clarify a bit more please?

you state "The only cells that have values is D Column", yet your formula is
checking cells on the '6' Row, L6, R6, and X6 for values greater than zero.

A bit more detail would surely help.
Rod

 

[Minty Fresh]

Not sure what you are after, but perhaps that will be easier to define by
examining what you have now.
=IF(L6>0,(D6*D$1),IF(R6>0,(D6*D$1),IF(X6>0,(D6*D$1),0)))
If L6 contains any data other than 0 it multiplies D1 by D6.
If L6 is either blank or contains a 0, the formula checks R6.
If RR contains any data other than 0 it multiplies D1 by D6.
If R6 is either blank or contains a 0, the formula checks X6.
If X6 contains any data other than 0 it multiplies D1 by D6.
If R6 is either blank or contains a 0, the formula returns 0 for the
value of F6.

If D is the only cell that contains a value, then the formula will always
return a 0.

 

[Minty Fresh]

Revised

Not sure what you are after, but perhaps that will be easier to define by
examining what you have now.
=IF(L6>0,(D6*D$1),IF(R6>0,(D6*D$1),IF(X6>0,(D6*D$1),0)))
If L6 contains any data other than 0 it multiplies D1 by D6.
If L6 is either blank or contains a 0, the formula checks R6.
If R6 contains any data other than 0 it multiplies D1 by D6.
If R6 is either blank or contains a 0, the formula checks X6.
If X6 contains any data other than 0 it multiplies D1 by D6.
If X6 is either blank or contains a 0, the formula returns 0 for the
value of F6.

If D is the only cell that contains a value, then the formula will always
return a 0.

 

[Mike]

What i want is right now i have a value in D6 & a value in F6, This formula
is for F6 & I WANT IT TO READ A ZERO VALUE just until values are entered in
celLs L6,R6,& X6 (D1=7.2,D6=50.4166, F6=363,L6,R6,X6 are blank till data is
entered

 

[Joe User]

This is the formula im using & i want it to read a zero value if these cells
are blank or read zero, The only cells that have values is D Column & this
formula is in F6 WHY WON,T THIS WORK
=IF(L6>0,(D6*D$1),IF(R6>0,(D6*D$1),IF(X6>0,(D6*D$1),0)))

I suspect because L6, R6 and X6 only __appear__ blank, but in fact they
contain a null string ("") or some other string that appears blank.

Following the logic of your IF statement (you want D6*D$1 if __any__ of L6,
R6 or X6 is greater than zero):

=IF(OR(N(L6)>0,N(R6)>0,N(X6)>0), D6*D$1, 0)

But if you want D6*D$1 only if __all__ of L6, R6 and X6 are greater than zero:

=IF(AND(N(L6)>0,N(R6)>0,N(X6)>0, D6*D$1, 0)

 

[Joe User]

Errata....

=IF(AND(N(L6)>0,N(R6)>0,N(X6)>0, D6*D$1, 0)

If you are copy-and-pasting (good idea), you might be stumped by an obvious
typo. That should be:

=IF(AND(N(L6)>0,N(R6)>0,N(X6)>0), D6*D$1, 0)


----- original message -----