Help with a function in Excel

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hello ppl and sorry if this isn't the right subforum to post my question.

But let me explain what I want to do.I have an excel sheet in which in column "D" I am going to add various values (for example 10,16,80,100 etc).I want to know if its possible to multiply those values with a specific number (12 particularly) and excel display straight away the result.

Every help will be much appreciated!!!

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi

don't you just type =d1*12 in whatever box you want the answer to appear in or am I being to simplistic?

 

greenbrucelee I probably didn't explain very well what I want.
I was wondering if the result could be displayed in the same cell that I enter each value.

 

I am sure there is a way but can't think of it right now, I haven't used excel properly for years/

 

That error I want to overcome because I want to use the same cell.

 

If I remember rightly it something to with putting the formula in the cells you are going to put the numbers into and making the formula stick, sort of like a macro then when you put your numbers in it calculates the results.

I just can't seem to think of what it is

 

asymvivastos,

An Excel cell can hold:

1. Data
2. Formula

You can't hold both in the same cell.

 

asymvivastos,

Why do you need to use the same cell?

 

thats the one

rep given as you have reminded me of how I did it at Uni.

 

Sparky,

Would that vb script be able to distinguish between pre-processed data and post-processed data?

 

if all he wants is whatever the numbers entered into the cell to multiply by 12 then why not?

I am sure thats the way I did it at Uni.

 

greenbrucelee,

I was just curious from a data integrity perspective of accidentally re-running the script on the post-processed data so instead of the original number times 12, it'll be the original number times 144 or higher.

 

yep I know what you mean it can happen as the integers could loop it happened to me before, the script would have to identify each cell so that didn't happen.

 

Sparky,

If we're going to use another column but hidden, then wouldn't it be easier to just create another column that holds the formula to multiply by 12?

 

Sorry to interrupt when you are asking Sparky but the poster wanted the same column/cell so when he enters 80 into say d1 it multiplys by 12