mae0429
07-01-2008, 10:54 AM
Hi everyone,
I typically don't write formulas, but I need one in this instance. I have:
=IF(NOT(Sheet1!$R$11 <> 1) *AND Sheet1!$R$12,3.696,NA())
but I'm getting a name error. What I'm trying to do is test if R11 = 1 (or whatever I set it to) AND R12 = True. If both are satisfied, the cell should be 3.696, otherwise it should be NA().
If you could explain what it should be and why that is, I'd sure appreciated it.
Thanks,
-Matt
I typically don't write formulas, but I need one in this instance. I have:
=IF(NOT(Sheet1!$R$11 <> 1) *AND Sheet1!$R$12,3.696,NA())
but I'm getting a name error. What I'm trying to do is test if R11 = 1 (or whatever I set it to) AND R12 = True. If both are satisfied, the cell should be 3.696, otherwise it should be NA().
If you could explain what it should be and why that is, I'd sure appreciated it.
Thanks,
-Matt