Multiplying a cell and displaying the result in the same cell

  • Thread starter Thread starter robspot
  • Start date Start date
R

robspot

Hi

Is it possible to perform a calculation on a cell (well a column) an
replace the data in the cell with the result? I have a spreadshee
which uploads data to a database (not sure which type - it's
mechanical estimating package) and I need to increase the price colum
by a certain percentage. I cannot add or delete any of the column
otherwise the upload won't work.

Thanks
Ro
 
Hi
try:
- enter your multiplication factor in an empty cell (e.g. 1.1)
- copy this cell
- select your imported data
- goto 'Edit - Paste Special' and choose 'Multiply
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
adding percentages to cells 5
how to multiply two values and round the result 5
Cell not calculating after importing data 2
multiplying cells and adding that answer in the same cell 3
Multiplying one cell by a column 5
Increase a value by a % with result showing in original cell? 1
cells containing text and numbers 5

Back
Top