Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.