Pacific Business Daily

How do I make an array formula in Excel for a pricing sheet with option of percentile reduction?

I need to make a pricing sheet where I can input a select amount of products and have it tally that amount. Example: cup $3.00 quantity=2 Dish $2.00 quantity=1 Total = $8.00 Minus 10%=$7.20

Public Comments

1. Use equations in the cells: for example to add cells together type "=SUM(cell1,cell2,.....)" into the box you want the sum to be in. to subtract 10% from the total in cellA and put that value into another cell use: "=.9*cellA" In case you are confused, each cell has a row and column number, so the cell in the top left corner of the screen would by cell "A1". The one to its right is "B1", the one below it is "A2" and so on. If you want to add A1 and B1 and put the total in cell A2, click on cell A2 and type =sum(A1,B1) and hit enter. Don't forget the equal sign. You can separate each number to be added by a comma (,) or if you are adding a whole column or row put the first cell and the last cell in the group separated by a colon (:), for example to add all the cell from A1 to A20 put =sum(A1:A20). Still confused, email me.