L
Laure
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)
either cell does not = x then use 0 (zero)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
WLMPilot
=IF(OR(D1<>x, D15<>x),0,xxxxxxxx) --> where xxxxxxxx is the criteria if
either cell does equal x.
Les
either cell does equal x.
Les
L
Laure
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.
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.
P
paul
=(IF(AND(D13="x",D19="x"),(C16+6)*C12*B9*B27,0))
paul
[email protected]
remove nospam for email addy!
paul
[email protected]
remove nospam for email addy!
L
Laure
Thanks that finally has it working.
paul said:=(IF(AND(D13="x",D19="x"),(C16+6)*C12*B9*B27,0))
paul
[email protected]
remove nospam for email addy!
W
WLMPilot
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.
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.
P
paul
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!
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!