Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple but need help!
I have a workbook sheet of different figures per cell and I need to add 2% to
each one of those figures as they are entered. I have looked through all of the help sheets but I can't find the appropriate formula to do this. Can you help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple but need help!
Right click sheet tabview codeinsert thischange columns I to suit.
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("I")) Is Nothing Then Exit Sub Application.EnableEvents = False If IsNumeric(Target) Then Target = Target * 1.02 Application.EnableEvents = True End Sub Sub fixincase() Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Lin242" wrote in message ... I have a workbook sheet of different figures per cell and I need to add 2% to each one of those figures as they are entered. I have looked through all of the help sheets but I can't find the appropriate formula to do this. Can you help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple but need help!
I am sorry, I cannot understand that. Maybe I should clarify my question.
My worksheet (MExcel 2003) already contains columns of dollar amounts that I want to add 2% to, and then as new dollar amounts are added they will automatically be increased by that same percentage. If you could simplify your answer slightly for me I'd really appreciate it. -- Lin242 "Don Guillett" wrote: Right click sheet tabview codeinsert thischange columns I to suit. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("I")) Is Nothing Then Exit Sub Application.EnableEvents = False If IsNumeric(Target) Then Target = Target * 1.02 Application.EnableEvents = True End Sub Sub fixincase() Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Lin242" wrote in message ... I have a workbook sheet of different figures per cell and I need to add 2% to each one of those figures as they are entered. I have looked through all of the help sheets but I can't find the appropriate formula to do this. Can you help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple but need help!
I'm not sure, but did you try: an equation for multiplying or adding 2%?
=sum(I4*.02) or (I4+.02)??? Hope this helps??? "Lin242" wrote: I am sorry, I cannot understand that. Maybe I should clarify my question. My worksheet (MExcel 2003) already contains columns of dollar amounts that I want to add 2% to, and then as new dollar amounts are added they will automatically be increased by that same percentage. If you could simplify your answer slightly for me I'd really appreciate it. -- Lin242 "Don Guillett" wrote: Right click sheet tabview codeinsert thischange columns I to suit. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("I")) Is Nothing Then Exit Sub Application.EnableEvents = False If IsNumeric(Target) Then Target = Target * 1.02 Application.EnableEvents = True End Sub Sub fixincase() Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Lin242" wrote in message ... I have a workbook sheet of different figures per cell and I need to add 2% to each one of those figures as they are entered. I have looked through all of the help sheets but I can't find the appropriate formula to do this. Can you help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple but need help!
I hope you didn't really intend to suggest =sum(I4*.02) ?
If you wanted =I4*.02, that will do the trick, and the SUM function is unnecessary. Look up the SUM function in Excel help to see its syntax. If you wanted =SUM(I4, I4*.02), then that would be appropriate syntax for the SUM function, but =I4*1.02 would be easier. -- David Biddulph "never" wrote in message ... I'm not sure, but did you try: an equation for multiplying or adding 2%? =sum(I4*.02) or (I4+.02)??? Hope this helps??? "Lin242" wrote: I am sorry, I cannot understand that. Maybe I should clarify my question. My worksheet (MExcel 2003) already contains columns of dollar amounts that I want to add 2% to, and then as new dollar amounts are added they will automatically be increased by that same percentage. If you could simplify your answer slightly for me I'd really appreciate it. -- Lin242 "Don Guillett" wrote: Right click sheet tabview codeinsert thischange columns I to suit. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("I")) Is Nothing Then Exit Sub Application.EnableEvents = False If IsNumeric(Target) Then Target = Target * 1.02 Application.EnableEvents = True End Sub Sub fixincase() Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Lin242" wrote in message ... I have a workbook sheet of different figures per cell and I need to add 2% to each one of those figures as they are entered. I have looked through all of the help sheets but I can't find the appropriate formula to do this. Can you help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |