Thread: One command in one cell initiating another command in another cel.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default One command in one cell initiating another command in another cel.
Formulas in a cell cannot change values in any other cell unless the other
cell has a formula referencing the first cell.

Q6, Z6 and E7 must have their own formulas referencing F2 value.

i.e. In Q6 =IF(F2=B5,N6,"not equal")


Gord Dibben MS Excel MVP

On Sat, 7 Nov 2009 08:42:01 -0800, Chas52
wrote:

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.

Reply With QuoteReply With Quote