Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a percantage formula in a cell?
Hi
how do I create a formula as below Enter a value in a cell; E.g Cell C5 and the formula automatically multiplys the value by say 30% and keeps the result in cell C5. Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a percantage formula in a cell?
Use the following event macro:
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("C5"), Target) Is Nothing Then Exit Sub End If Application.EnableEvents = False Target.Value = 0.3 * Target.Value Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200723 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a percantage formula in a cell?
You can't do that by a formula, but if you put 30% in a cell, copy it, then
select C5, edit/ paste special/ multiply, that will do it. -- David Biddulph "byway" wrote in message ... Hi how do I create a formula as below Enter a value in a cell; E.g Cell C5 and the formula automatically multiplys the value by say 30% and keeps the result in cell C5. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula that makes text in a cell = 0 | Excel Worksheet Functions | |||
Create a formula using cell format | Excel Discussion (Misc queries) | |||
create cell formula for... | Excel Worksheet Functions | |||
How do I create a formula where a cell is automatically shaded ? | Excel Worksheet Functions | |||
How do I create formula to change cell color | Excel Worksheet Functions |