![]() With such a small data set, you may think why not just do it manually. The original values are in column A, with the heading Voltage (V). The correction involves subtracting 3 volts. In the following sheet, we have a sample of voltage measurements taken, that need to be corrected. Subtract a single value from a range of cells using a formula ![]() So, whether subtracting a value from a range or cells, or vice versa, it turns out that Excel can perform both with relative ease. ![]() Or perhaps you’ve had to make a correction to a series of data values such as temperatures, voltage measurements, or exam grades, by subtracting a value contained in another cell? Have you ever come across the situation where you have a running total, perhaps the sum of incoming payments, from which you have to subtract values from a range of cells, possibly representing expenditures? ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |