Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell to equal have of what I put in
how do I make a cell equal half of whatever $ amount I put in?
If I type in 23.50 (Accounting format) I want it to say $11.75 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell to equal have of what I put in
You can scale either a single cell or a range of cells ( column, row,
whatever). In an unused cell enter ..5 and copy this cell. Then select the cells you want to adjust and paste/special with multiply checked. -- Gary's Student gsnu200712 "lili" wrote: how do I make a cell equal half of whatever $ amount I put in? If I type in 23.50 (Accounting format) I want it to say $11.75 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell to equal have of what I put in
=A1/2
"lili" wrote: how do I make a cell equal half of whatever $ amount I put in? If I type in 23.50 (Accounting format) I want it to say $11.75 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell to equal have of what I put in
To do this automatically would require an event macro:
Put this in your worksheet code module (right-click the worksheet tab and choose View Code): Private Sub Worksheet_Change(ByVal Target As Excel.Range) Const cdSCALE As Double = 0.5 'change to suit With Target If .Count = 1 Then If .Address(False, False) = "E5" Then 'change E5 to suit On Error Resume Next Application.EnableEvents = False .Value = Application.Round(.Value * cdSCALE, 2) Application.EnableEvents = True End If End If End With End Sub I used Round() since you're talking about currency. If you want half-pennies, use .Value = .Value * cdSCALE instead. Note that format of cells (other than Text) doesn't affect how inputs are parsed or stored. In article , lili wrote: how do I make a cell equal half of whatever $ amount I put in? If I type in 23.50 (Accounting format) I want it to say $11.75 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Setting a cell equal to another worksheet cell fails (sometimes) | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel |