How could I reduce the length of the code?

Excel Help, Helping of making a code? Width X Length = CODE?

• Im currently doing a School Project for a business class. I need to make an excel spreadsheet with formulas. In column A will represent my width of my product, in column B will represent the length, I want column C to represent the code. Max widths and lengths range from 0-999. Example if I put a width in of 300 and length of 300 the code will be 456320 (each code will be a 6 no code) the codes are made up of 100 intervals, so if the width is 301x300 the code will differ 456321. I need to know how to make a FORMULA where I can enter all the codes in the background and based on entering the width and the length the code will change. WIDTH X LENGTH = CODE AxB=C 100x100=100000 100x101=100010 900X900=900000 Please help.

• Answer:

  With excel and spreadsheets, you ALWAYS start a formula with an equal sign ". =" So, for this EXTREMELY SIMPLE function, the basics of excel, you would do in C1: "=A1*B1" . A little black box will appear in the bottom right corner of C1 after you type what i just typed, DRAG this box from C1 all the way down as far as A and B go, so that C2 says "=A2*B2", C3 says "=A3*B3", and so on. Do not include any quotes i just typed.