![]() ![]() The usual practice is to copy the formula for each line and leave it to update when a new item is entered. We don’t want to have to remember to write out the formula, or even copy or drag it down to our new “items sold” for each addition. Instead of looking up the inventory number, we use a SUMIF statement that looks for the inventory name matching the item we sold, and then fills in the inventory number for that item. We have a tab for when we purchase inventory, and another for when we sell inventory. When setting up a spreadsheet into which you import, add, or copy and paste data frequently, it can be a pain to drag or copy formulas down to your new data.įor example: We created a spreadsheet in which to track inventory for our gift shop. That can be important, or at least a time-saver. But did you know that the IF statement can help you keep your sheets looking clean and more readable? It’s used for looking up data or making calculations under specific conditions. The IF statement surely is among the most commonly-used formulas in Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |