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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(D6*D$1 ),0)))

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
R60 Or X60 then use this below formula.
=IF(OR(L60,R60,X60),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(L60,R60,X60),D6*D$1,0)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Mike" wrote:

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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(D6*D$1 ),0)))

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



"Mike" wrote:

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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(D6*D$1 ),0)))

Not sure what you are after, but perhaps that will be easier to define by
examining what you have now.
=IF(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(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.

"Mike" wrote:

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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(D6*D$1 ),0)))

Revised

"Minty Fresh" wrote:

Not sure what you are after, but perhaps that will be easier to define by
examining what you have now.
=IF(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(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" wrote:

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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(D6*D$1 ),0)))

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

"Minty Fresh" wrote:

Revised

"Minty Fresh" wrote:

Not sure what you are after, but perhaps that will be easier to define by
examining what you have now.
=IF(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(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" wrote:

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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(D6*D$1 ),0)))

"Mike" wrote:
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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(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)

Errata....

I wrote:
=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 -----

"Joe User" <joeu2004 wrote in message
...
"Mike" wrote:
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(L60,(D6*D$1),IF(R60,(D6*D$1),IF(X60,(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)