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

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?

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=525653

Forgot to say

Then copy down as far as required.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=525653

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

"EdMac" wrote:


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?

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=525653

Glad to have helped - thanks for the feedback.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=525653