I want to subtract two numbers. The numbers are categorized, e.g. cell N2 (WAS) and N3 (IS). The cells populated are N1 thru N351. I want to calculate the difference between the two cells. If the N2 (WAS) cell is less than the N3 (IS) cell, e.g. N2 < N3, then it is a positive number. If N2 (WAS) cell is greater than the N3 (IS) cell, then it is a negative number. If the two cells are equal then the result would be 0.
Examples:
(WAS) Row 2-----N2 = 346.18-----(IS) Row 3-----N3 = 347.00-----M3 = 0.82
(WAS) Row 4-----N4 = 484.00-----(IS) Row 5-----N5 = 483.50-----M5 = -0.50
(WAS) Row 6-----N6 = 22.75-----(IS) Row 7-----N7 = 22.75-----M7 = 0.00
Rows go from 2 thru 351
If you need further clarification, don't hesitate to ask. I appreciate the help.
برچسب:
نویسنده: استخدام کار