Thread: linking a cell with a specific letter value to a cell with a formu
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EdMac
 
Posts: n/a
Default linking a cell with a specific letter value to a cell with a formu

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

Reply With QuoteReply With Quote