Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Another excel question. I'm using Excel 2010.

If for example I have a value in cell A1, lets say 2.59

What I want to do is multiply that cell by 1.333 but in the same cell

I don't want to have to put a formula in B1 such as =(A1*1.333), because I already have a value in B1 and I don't want to have to insert a new column.

if I highlight cell A1 and put the formula =(A1*1.333) into it the value becomes 0.00

Can what I'm asking be done? or would I need to create a macro?

Any help would be appreciated.

Thanks

share|improve this question
    
I wondered this myself, I never found a way so my answer is no (although I am happy to be proved wrong). – Dave Sep 13 '13 at 11:18

If you can spare 1 cell somewhere else in the worksheet/book, you can type 1.333 in that cell, copy that cell and then select A1, "Paste Special" > "Multiply".

This works for multiple selections to multiply :)

After that, delete the cell containing 1.333.

share|improve this answer
up vote 1 down vote accepted

The below VBA macro appears to work:

Public Sub Convert()
    Dim Cell As Range
    For Each Cell In Selection
        If Not IsError(Cell) Then Cell = Cell *1.333
    Next Cell
End Sub
share|improve this answer

try this macro

Sub multiply()
ActiveCell = ActiveCell * 1.333 
End Sub
share|improve this answer
    
why -1 for the macro – house Sep 16 '13 at 16:47
    
That works great for one cell! Thanks alot! If there were several cells that i've selected how would i write the macro then? As the one you gave I would need to do it one by one. – Jez Vander Brown Sep 19 '13 at 13:38
    
you need to put that in the question – house Sep 26 '13 at 17:57

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .