in [Functions]

Prev: can I autopopulate from a long drop down list in Excel?
Next: Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
From: barkingmad on 11 Feb 2010 10:49 Ms Office Excel 2003 ( Ms Office Professional Edition 2003) I want to 'embed' a formula (eg: *.05) in multiple cells so that when data is then entered into the cells it operates on the data and displays the result. For instance, in the example given, if I then entered '16' into a cell the figure displayed would be '0.8'
From: Mike H on 11 Feb 2010 10:55 Hi, One way. Put 0.05 in a cell and give the cell a name (e.g. Factor) then in any other cell you can enter =16*factor and get the answer you require -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "barkingmad" wrote: > Ms Office Excel 2003 ( Ms Office Professional Edition 2003) > > I want to 'embed' a formula (eg: *.05) in multiple cells so that when data > is then entered into the cells it operates on the data and displays the > result. For instance, in the example given, if I then entered '16' into a > cell the figure displayed would be '0.8'
From: Gord Dibben on 11 Feb 2010 12:36
Not within the same cell unless you were to use VBA. See Mike's reply for use of a helper cell. For the VBA part............... Right-click on the sheet tab and "View Code" Copy/paste this code into that module. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Const WS_RANGE As String = "A1:A10" 'adjust to suit If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then If Not IsNumeric(Target.Value) Then Exit Sub Application.EnableEvents = False With Target .Value = .Value * 0.05 Application.EnableEvents = True End With End If End Sub Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 07:49:03 -0800, barkingmad <barkingmad (a)discussions.microsoft.com> wrote:>Ms Office Excel 2003 ( Ms Office Professional Edition 2003) > >I want to 'embed' a formula (eg: *.05) in multiple cells so that when data >is then entered into the cells it operates on the data and displays the >result. For instance, in the example given, if I then entered '16' into a >cell the figure displayed would be '0.8' |