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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Empty Cell calculation | Elan | Worksheet Functions | 2 | April 12th, 2005 02:15 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
one time calculation for a cell | Don Guillett | Worksheet Functions | 2 | March 26th, 2004 12:02 AM |
Conditional Cell Calculation | Mark T. | Worksheet Functions | 6 | February 15th, 2004 05:34 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |