I am creating a running inventory sheet. In most of the cells, there will be a serial number that I need to count as -1 from inventory count. In stock will be calculated separately, I need to continually subtract from In Stock to get my Available total.
What formula should I use?
In example: All sites will have either Hardware 1 or Hardware 2. Most (but not always) will have a PC and Printer too. I am guessing I need to use =IF(ISBLANK) but I have never used that formula before. How do I set up for list of about 100 lines?
<tbody>
</tbody>
<tbody>
</tbody>
What formula should I use?
In example: All sites will have either Hardware 1 or Hardware 2. Most (but not always) will have a PC and Printer too. I am guessing I need to use =IF(ISBLANK) but I have never used that formula before. How do I set up for list of about 100 lines?
| A | B | C | D | E | F |
| 1 | Inventory: | Hardware 1 | Hardware 2 | PC | Printer |
| 2 | In Stock | 10 | 14 | 8 | 7 |
| 3 | Available | 8 | 12 | 4 | 3 |
| 4 | |||||
| 5 | Hospital 1 | 1 | XYZ1234XYZ | ABC4321ABC | |
| 6 | Hospital 2 | 1 | UVW1234UVW | ||
| 7 | Hospital 3 | 1 | |||
| 8 | Hospital 4 | 1 | |||
| 9 | |||||
| 10 | |||||
| 11 |
<tbody>
</tbody>
<tbody>
</tbody>
