ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Percents (https://www.excelbanter.com/excel-worksheet-functions/181960-percents.html)

Sharon

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

Pete_UK

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



Max

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


Sharon

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.

Max

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.





All times are GMT +1. The time now is 07:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com