View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Georgeh Georgeh is offline
external usenet poster
 
Posts: 4
Default dropdown list and formulas

Thank you Dave,
Yes I am using data verification. Is there a methode that I can use from a
dropdown list to insert a formula that is relative to each item in the list?

"Dave Peterson" wrote:

First, you don't need the =sum() function.

Second, are you using data|validation?
If yes, then this won't work. You'll see the actual text of the formula.




Georgeh wrote:

I am trying to use a dropdown list to insert a formula into a cell. Each item
in the list has a different formulaĆ¢‚¬Ā¦.this being
one(=SUM(D8-(D8/0.1)/31.25)/55)
Thank you


--

Dave Peterson