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
|