This might be answered somewhere already, but I'm horrible at explaining what I need or looking for, so bear with me as I try to explain this.
I'm trying to set up a sheet that can split up the cost of ordered signs that I made for several different jobs. Basically what I want is that when I input a number in a cell that cell is multiplied by another number, if that makes sense. I have fixed prices for the cost of several signs and I have all the different jobs lined up so I add the quantity the job is using I want it to automatically multiply the quantity with the fixed price, in that cell not a separate cell, but I cant figure it out. I don't want to create a whole new row to get the product of the quantity and the price.
So for example sign 1 is $10, sign 2 is $15; job 1 used only sign 1 three times, job 2 used sign 2 five times, and job 3 used both sign 1 3 times and sign 2 four times. So I want to be able to input 3 under job 1 and have it multiply in that cell; not only do I need the total amount each job is costing but the an individual itemized cost breakdown.
Any help would be greatly appreciated.
