Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percents
Hi I have an amout in a cell and need to add 1.5% to get the currect number
for the cell next to it. Can anyone help????? Thank You |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percents
With data in A1, try this:
=A1 * 1.015 Copy down as required. Hope this helps. Pete On Apr 1, 12:46*am, Sharon wrote: Hi I have an amout in a cell and need to add 1.5% to get the currect number for the cell next to it. Can anyone help????? Thank You |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percents
One way
In B1: =A1*101.5% -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Sharon" wrote: Hi I have an amout in a cell and need to add 1.5% to get the currect number for the cell next to it. Can anyone help????? Thank You |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percents
Hi Thank you SOOOOOOOOOO much it worked and got past that area, now I am
working on APR for a year. Excel does not come easy for me, glad you helped out thanks again. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percents
No prob. Do note that Pete's response would also give you the same result.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Sharon" wrote in message ... Hi Thank you SOOOOOOOOOO much it worked and got past that area, now I am working on APR for a year. Excel does not come easy for me, glad you helped out thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percents | Excel Discussion (Misc queries) | |||
Percents and Text in one cell - need to add percents only | Excel Discussion (Misc queries) | |||
Percents | Excel Discussion (Misc queries) | |||
Formula - Percents | Excel Discussion (Misc queries) | |||
Hyperlink problem with percents | Excel Discussion (Misc queries) |