PDA

View Full Version : Solved: Formula help



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

mdmackillop
07-01-2008, 11:01 AM
=IF(AND(Sheet1!$R$11 =1, Sheet1!$R$12),3.696,NA())

mae0429
07-01-2008, 11:06 AM
Perfect, thank you :)