David Roberts
New Member
- Joined
- Jan 11, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I'm trying to work out a formula that give me the correct return in 'E' based on the difference between 'C' and 'D'
I'm trying =SUM(ABS(C2:D2)) This seems to work for answers £51.00 (E2) and £50.00 (E3), but I can't get E4 to equal £49.00
Regards
Dave
I'm trying =SUM(ABS(C2:D2)) This seems to work for answers £51.00 (E2) and £50.00 (E3), but I can't get E4 to equal £49.00
Regards
Dave