How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)

=IF(OR(D1<x, D15<x),0,xxxxxxxx) -- where xxxxxxxx is the criteria if
either cell does equal x.

Les



"Laure" wrote:

How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)

Won't accept that entry. My formula needs to be:

If the value in cell D13=letter X and the value in cell D19=letter X then
add 6 to the value in C16, multiply that by the value of C12, multiply that
by the value of B9; multiply that by the value of B27. Should either D13 or
D19 not equal the letter X than show the value of O (zero). Thus using your
format the formula would read:

=IF(OR(D13<X,D19<x,0,((((C16+6)*C12)*B9))*B27))) and each time I enter
that formula it tells me I have and error.

"WLMPilot" wrote:

=IF(OR(D1<x, D15<x),0,xxxxxxxx) -- where xxxxxxxx is the criteria if
either cell does equal x.

Les



"Laure" wrote:

How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)

=(IF(AND(D13="x",D19="x"),(C16+6)*C12*B9*B27,0))

paul

remove nospam for email addy!



"Laure" wrote:

Won't accept that entry. My formula needs to be:

If the value in cell D13=letter X and the value in cell D19=letter X then
add 6 to the value in C16, multiply that by the value of C12, multiply that
by the value of B9; multiply that by the value of B27. Should either D13 or
D19 not equal the letter X than show the value of O (zero). Thus using your
format the formula would read:

=IF(OR(D13<X,D19<x,0,((((C16+6)*C12)*B9))*B27))) and each time I enter
that formula it tells me I have and error.

"WLMPilot" wrote:

=IF(OR(D1<x, D15<x),0,xxxxxxxx) -- where xxxxxxxx is the criteria if
either cell does equal x.

Les



"Laure" wrote:

How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)

Thanks that finally has it working.

"paul" wrote:

=(IF(AND(D13="x",D19="x"),(C16+6)*C12*B9*B27,0))

paul

remove nospam for email addy!



"Laure" wrote:

Won't accept that entry. My formula needs to be:

If the value in cell D13=letter X and the value in cell D19=letter X then
add 6 to the value in C16, multiply that by the value of C12, multiply that
by the value of B9; multiply that by the value of B27. Should either D13 or
D19 not equal the letter X than show the value of O (zero). Thus using your
format the formula would read:

=IF(OR(D13<X,D19<x,0,((((C16+6)*C12)*B9))*B27))) and each time I enter
that formula it tells me I have and error.

"WLMPilot" wrote:

=IF(OR(D1<x, D15<x),0,xxxxxxxx) -- where xxxxxxxx is the criteria if
either cell does equal x.

Les



"Laure" wrote:

How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)

Sorry it did not work. Would have helped to know exactly the formulas you
needed to execute based on the values and that the values were "x" instead of
me interpreting that x represented what ever the value in the cell was.



"Laure" wrote:

Won't accept that entry. My formula needs to be:

If the value in cell D13=letter X and the value in cell D19=letter X then
add 6 to the value in C16, multiply that by the value of C12, multiply that
by the value of B9; multiply that by the value of B27. Should either D13 or
D19 not equal the letter X than show the value of O (zero). Thus using your
format the formula would read:

=IF(OR(D13<X,D19<x,0,((((C16+6)*C12)*B9))*B27))) and each time I enter
that formula it tells me I have and error.

"WLMPilot" wrote:

=IF(OR(D1<x, D15<x),0,xxxxxxxx) -- where xxxxxxxx is the criteria if
either cell does equal x.

Les



"Laure" wrote:

How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)

yes i stepped over your prone form to reach my goal!
one thing though.You needed to use AND not OR.Or will evaluate to true if
either of the two cells had x in them buut the OP told us that they both had
to have x in em.
Sorry if I am stating the obviuos and there was a misunderstanding of the
OP.I sometimes completely misunderstand the intention as well!
--
paul

remove nospam for email addy!



"WLMPilot" wrote:

Sorry it did not work. Would have helped to know exactly the formulas you
needed to execute based on the values and that the values were "x" instead of
me interpreting that x represented what ever the value in the cell was.



"Laure" wrote:

Won't accept that entry. My formula needs to be:

If the value in cell D13=letter X and the value in cell D19=letter X then
add 6 to the value in C16, multiply that by the value of C12, multiply that
by the value of B9; multiply that by the value of B27. Should either D13 or
D19 not equal the letter X than show the value of O (zero). Thus using your
format the formula would read:

=IF(OR(D13<X,D19<x,0,((((C16+6)*C12)*B9))*B27))) and each time I enter
that formula it tells me I have and error.

"WLMPilot" wrote:

=IF(OR(D1<x, D15<x),0,xxxxxxxx) -- where xxxxxxxx is the criteria if
either cell does equal x.

Les



"Laure" wrote:

How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)