Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I create a spread sheet to automatically calculate when I
On a new spread sheet I am entering numbers and I would like them to be
multiplied and changed automatically. The formula is x*3 then less 40%. Can anyone help me. |
#2
|
|||
|
|||
One way:
If you are entering your numbers in column A, say, then in column B enter: B1: =(A1*3)*(1-40%) or, better, B1: =A1*3*60% copy B1 down as far as necessary. In article , wbinfo wrote: On a new spread sheet I am entering numbers and I would like them to be multiplied and changed automatically. The formula is x*3 then less 40%. Can anyone help me. |
#3
|
|||
|
|||
Do you want them changed in the same cell in which you type them?
You would then have no paper trail for checking errors in input. John's suggestion about having a formula in a separate column is the safest way to go. If you want to change them as you enter paste this code into a sheet module. Private Sub Worksheet_Change(ByVal Target As Excel.Range) 'when entering data in a cell in Col A On Error GoTo enditall Application.EnableEvents = False If Target.Cells.Column = 1 Then n = Target.Row If Excel.Range("A" & n).Value < "" Then With Excel.Range("A" & n) .Value = .Value * 3 * 0.6 End With End If End If enditall: Application.EnableEvents = True End Sub Gord Dibben Excel MVP On Wed, 28 Sep 2005 09:42:02 -0700, wbinfo wrote: On a new spread sheet I am entering numbers and I would like them to be multiplied and changed automatically. The formula is x*3 then less 40%. Can anyone help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create summary based on specifc value in a different sheet | Excel Worksheet Functions | |||
Create a sheet name, won't let me, says already sheet named that | Excel Worksheet Functions | |||
how do I make a new spread sheet pop up, based on an entry in a c. | Excel Discussion (Misc queries) | |||
Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) |