-
Solved: Formula help
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
-
=IF(AND(Sheet1!$R$11 =1, Sheet1!$R$12),3.696,NA())
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Perfect, thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules