I would like to create a cell that directs a number of cells formulas. eg. If
I direct F2=B5, then Q6 will equal N4, Z6 will equal F9 and E7 will equal K1.
Not sure what you mean by 'commanding' or 'directing' a cell. A formula can't
reach out and change the value in another cell, delete coluns, insert rows,
etc. A formula just attempts to compute some kind of value and returns it to
the cell containing the formula. A formula can look at the values in other
cells as part of the computation. Try this:
In Q6, enter =IF(F2=B5,N4,0)
In Z6, enter =IF(F2=B5,F9,0)
In E7, enter =IF(F2=B5,K1,0)
Hope this helps,
Hutch
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.