Well, it's pretty obvious that this amount is not 10 percent of the first two columns. The formula adds the Material and Labor cells, and then, multiplies that amount by the buffer percentage cell. When we are finished, we'll be able to change this number, if we want to calculate a different Cost buffer amount with our formula. Then, come up here to the Number group and click the % button to format the cell as a percentage.
The first thing we need is a cell to hold the percentage amount. We could format the data as a table, but let's leave it as is for this demonstration. The formula we are going to write will go in this column and use the amounts in these two columns and a percentage amount.
Then, double-click the worksheet tabs and type names. I am going to show you how to write a basic formula to demonstrate a couple of important concepts.įirst, to help us keep everything straight, let's click this + sign to add a new worksheet.
0 kommentar(er)
