drewszone32
Member
I am having a brain freeze. What formula can I use to subtract positive and negative numbers.
Example
base # 8,000,000 - the following numbers below in cells. The issue is when I get to the last two calculations ( which are negative numbers), it is adding them instead of subtracting. My goal is to have a formula I can use for all criteria's.
8,000,000 5,834,610 2,165,390
8,000,000 6,060,210 1,939,790
8,000,000 6,088,853 1,911,147
8,000,000 488,798 7,511,202
8,000,000 35,173 7,964,827
8,000,000 327,044 7,672,956
8,000,000 648,627 7,351,373
8,000,000 734,862 7,265,138
8,000,000 217,564 7,782,436
8,000,000 267,872 7,732,128
8,000,000 -545,776 8,545,776
8,000,000 -2,477,589 10,477,589
Example
base # 8,000,000 - the following numbers below in cells. The issue is when I get to the last two calculations ( which are negative numbers), it is adding them instead of subtracting. My goal is to have a formula I can use for all criteria's.
8,000,000 5,834,610 2,165,390
8,000,000 6,060,210 1,939,790
8,000,000 6,088,853 1,911,147
8,000,000 488,798 7,511,202
8,000,000 35,173 7,964,827
8,000,000 327,044 7,672,956
8,000,000 648,627 7,351,373
8,000,000 734,862 7,265,138
8,000,000 217,564 7,782,436
8,000,000 267,872 7,732,128
8,000,000 -545,776 8,545,776
8,000,000 -2,477,589 10,477,589
