I need to know how to get excel to add 10% to a number i put into a cell
Any help appreciated
thanks
I need to know how to get excel to add 10% to a number i put into a cell
Any help appreciated
thanks
Hi
say A1 has 100 then enter this in B1
=A1*10%
Which will return 10
If you want to add the 10% to the 100 then you would use
=A1+(A1*10%)
VBA Noob
Hi
click on help - a side window will open - type percent in the box - click offline help in the dropdown menu - yep you guessed it click the green arrow Read through the results.
The offline help is really good works for thicko's like me with quite basic search words.
Tip ! you have 4 search words % add percent percentage if one word for what you are looking for does not work look for another which is relivant usually works
Tiler
Put
=A1*1.1
in a blank cell, replacing the A1 with the cell you want increased
Ben Van Johnson
Here's a macro you could use
enter 1.10 into A1
Run the Macro
it selects the Value from A1
then Multiplies the values in column B
Sub TenPercent()
Range("A1").Select
Selection.Copy
range("B1:B25").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlMultiply, SkipBlanks:= _
False, Transpose:=False
Range("A1").Select
Application.CutCopyMode = False
End Sub
Last edited by davesexcel; 09-05-2006 at 11:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks