ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problems with excel please help (https://www.excelbanter.com/excel-discussion-misc-queries/20851-problems-excel-please-help.html)

Paul Moseley

Problems with excel please help
 
I am new to excel and can't find an answer to my problem i'm sure its
easy. I have a cell/field with about 100 numbers in which i want to
copy which ive done and then multply it by 100 and display the result
automaticallyhow can this be done.

Barb R.

If you just want to multiply cell A1 by 100 and put the result in B1, you
need the following equation in B1
=A1*100

"Paul Moseley" wrote:

I am new to excel and can't find an answer to my problem i'm sure its
easy. I have a cell/field with about 100 numbers in which i want to
copy which ive done and then multply it by 100 and display the result
automaticallyhow can this be done.


Fredrik Wahlgren


"Paul Moseley" wrote in message
om...
I am new to excel and can't find an answer to my problem i'm sure its
easy. I have a cell/field with about 100 numbers in which i want to
copy which ive done and then multply it by 100 and display the result
automaticallyhow can this be done.


You can use Paste special to do this. Here's a description:
http://www.j-walk.com/ss/excel/usertips/tip059.htm

/Fredrik




All times are GMT +1. The time now is 03:01 PM.

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