How to input a 1 or 2 or 3 into a cell and have it multiply by a set number

Essentially, I would like to put a 1 into a cell and it converts into 1000. Or two into 2000 or three into 3000 etc etc. I have no idea how to make the proper formula and there must be one! Help!

By formula, you can do the following.

If you insert those numbers (e.g. 1 2 3) into cells A1, B1 and C1. In cell A2, you can type in the formula

Formula:

Please Login or Register  to view this content.

and copy it across to the right.

Not quite what I was looking for but similar. If I put 1 into A1, I want A1 to read 1000. The premise is each column represents an award based on a sale. If a 1 is put in that box for that day, the award represents 1000. 2 sales that day would represent 2000 and so on. So I have the criteria for the award in text, below that the amount it's worth (ie 1000). Below that is each day. I'd like each person to be able to input how many sales they had that day and the cell they put that number in equal the amount of the award. That make sense? LoL

In that case my answer is, can't be done without the use of VBA. Not the way you describe it I don't think.

What I would recommend is having columns for people to put in number of sales, then in a separatte column, multiple them by 1000, to get the awards.

Row/Column	A	B	C
1		# of Sales	Awards
2	Today	1	1000	=B2*1000
3	Tomorrow	2	2000	=B3*1000
4	Day after	3	3000	=B4*1000
5	etc.	INPUT HERE

Ooh, good one nflsales. Something new to learn.

One question though, does that option follows along with the workbook or is it system specific? E.g. I do this in Computer A, saves a file and sends it to Computer B. Does that option impact Computer B if it opens that workbook?

I may sound very ignorant, but I am doing this for coworkers and I'm ok with Excel but not advanced. Hence, I cannot find advanced options in excel 2010...

I found it thank you so much!