If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I 'embed' a formula to affect numbers as they're entered?
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' |
#2
|
|||
|
|||
Can I 'embed' a formula to affect numbers as they're entered?
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' |
#3
|
|||
|
|||
Can I 'embed' a formula to affect numbers as they're entered?
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 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' |
Thread Tools | |
Display Modes | |
|
|