SSPoulin23
New Member
- Joined
- Nov 21, 2014
- Messages
- 44
Hi all,
I need a formula to accomplish the following and I can't figure this out (having a weird week).
Column E has the original contract amount. If there is an adjustment, the new amount is entered into Column F. All adjustments need to net to 0. I need a formula that will tell me if the adjustments net to 0 or not. it can really be in any cell. I have a total at the end of each column that can be used in the formula if you think it's useful. I don't have room for another column that says what the adjustment is for each line.
...E ..... F
1 5000 20000
2 15000 5000
3 50000
4 10000 15000
5 20000 10000
6
7 100000 50000 (totals)
I know this is probably very simple but I'm just off point today - I can't even think of how to word my simple question to search for an answer. Any help will be greatly appreciated! Have a great day!
thanks,
sarah
I need a formula to accomplish the following and I can't figure this out (having a weird week).
Column E has the original contract amount. If there is an adjustment, the new amount is entered into Column F. All adjustments need to net to 0. I need a formula that will tell me if the adjustments net to 0 or not. it can really be in any cell. I have a total at the end of each column that can be used in the formula if you think it's useful. I don't have room for another column that says what the adjustment is for each line.
...E ..... F
1 5000 20000
2 15000 5000
3 50000
4 10000 15000
5 20000 10000
6
7 100000 50000 (totals)
I know this is probably very simple but I'm just off point today - I can't even think of how to word my simple question to search for an answer. Any help will be greatly appreciated! Have a great day!
thanks,
sarah