Positive & Negative values on Excel
I need a formula that will calculate the differnce from one column to the other in a row. However, sometimes the number in column A is bigger, and sometimes the number in column B is bigger. How do I get it to calculate the difference with the correct positive or negative value?
Im lookin for a formula that I can "set and forget" and copy the work books week to week.
Below is the table Im using. Its not an issue when the physical count value is larger than the TBS QTY value. But if youre looking at the last row, TBS is larger than physical, if I use the =sum(E-F) formula, I have to change the column numbers,(which If Im doing that, I might as well do the math myself) but week to week, the numbers change, and I dont want to have to change the formula each week, for each row.
Is this do-able, or am I just being lazy?
[link] [comments]
Want to read more?
Check out the full article on the original site