(Note that column C has been recalculated to show the results of a 5% increase in unit prices. Now select cell B2, and go Edit > Paste Values (Numbers '09) or Edit > Paste Formula Results (Numbers 3) With the cells shown still selected, Copy (command-C) If you increase the unit price by 5%, that will also increase the total price of n units by 5%, provided you multiply the quantity by the new unit price instead of the old unit price.įormula in C2, and filled down column C: =A*BĪdd a new column (D) to hold the formula for the increased price. If I'm reading the description of your table correctly, column A shows the number of units, column B the price of each unit, and column C the price of that quantity of units. You wrote: " I need to do this with 2 column actually A and B, both column need to be added by that 5%, I think this only possible"
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |