linking a cell with a specific letter value to a cell with a formu

T

tommo64

i dont know if this is possible but il give it a shot. i want to link a cell
with a letter value in it to a cell with a formula in it. so whenever a cell
with a specific letter value appears, in the cell ive linked it to, a
specific formula linked to that letter value will appear.
eg, D appears in one cell, the cell linked to it should display; =-A10
if H appears in the cell, the cell linked to it should display; =+A10
(or somthing like that)

at the moment im putting in the formula manually next to every cell where
the letter appears and it would save me a great deal of time if i could
figure this one out, any help would be appreciated

thanks
tom
 
T

Terry Gregg

tommo64 said:
i dont know if this is possible but il give it a shot. i want to link a cell
with a letter value in it to a cell with a formula in it. so whenever a cell
with a specific letter value appears, in the cell ive linked it to, a
specific formula linked to that letter value will appear.
eg, D appears in one cell, the cell linked to it should display; =-A10
if H appears in the cell, the cell linked to it should display; =+A10
(or somthing like that)

at the moment im putting in the formula manually next to every cell where
the letter appears and it would save me a great deal of time if i could
figure this one out, any help would be appreciated

thanks
tom
Click to expand...
If I have understood your problem correctly you could put a formula of
=if(a1="D",-A10,if(a1="H",+A10,"")) The "" will mean the cell is blank
if neither "D" or "H" are in the original cell, you can replace this
with zero if you wish.
 
E

EdMac

Hi Tom,

Unless I've misunderstood you, what you want is like this:

letter goes in say A1, formula to appear in DI

So in D1 enter =IF(A1="D",-A10,If(A1="H",A10,if(A1=Z,........)))

You can have up to 7 conditions this way.

Does this help?

E
 
T

tommo64

EdMac your a genius, youve cut out months of menial work, i am eternally
greatful
tom
 
Top