Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculation within a Cell
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. |
#2
|
|||
|
|||
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 -- Regards, Peo Sjoblom "Eric Whittaker" wrote in message ... 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. |
#3
|
|||
|
|||
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Eric Whittaker" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |