Conditional formulas between multiple worksheets



Here's the problem:

I want excel to autofill a formula across a range of cells. This formula
has several logical tests in it, and all of these test are mutually
exclusive. When I autofill now, this formula changes the cell values for the
outputs (which I want), but it also changes the inputs for the logical tests
(which I don't). I want excel to lock the logical test cell references when
I autofill, but still change the true/false outputs as normal. More
concretely, if I entered this into A1 of worksheet3:


How do I make excel do this:

That is, keep A1 locked, but vary B2, instead of:

when I autofill A2 of worksheet 3?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question