Calculation within a Cell

  • Thread starter Thread starter Eric Whittaker
  • Start date Start date
E

Eric Whittaker

I am trying to create cells that will make calculations for me. For example,
I want to enter the number 140, and have the cell automatically make the
calculation to 30 percent of that number. Any suggestions? Thanks.
 
You would need macro for that


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Range("A2"), Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Value = Target.Value * 0.3
Application.EnableEvents = True
End Sub

will change whatever number is entered in A1

for information see

http://www.mvps.org/dmcritchie/excel/event.htm
 
Or enter the number in A1 and in B1 use the formula =A1*1.30
The asterisk (star) is the multiplication symbol used by most computer
programs
best wishes
 
Back
Top