|
if + if
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 + if
=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 + if
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 + if
|
if + if
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) |
if + if
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) |
| All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com