Hello!
So, this is probably a basic math and an easy enough formula (famous last words!) but sometimes our cost is a negative sum due to a buy-back scheme that we operate.
Usually, to work out the cost total would be to add both but when this negative sum is calculated, it should still come off our cost price but instead it adds, it can become easily confusing - as an example.
Cost A - £3,336.00
Cost B is -£56.07
In excel, the total cost is worked out as £3,392.07
> However, it should be £3,279.93
Cost B is variable depending on the buy-back value.
What formula could be used so if it were a negative sum in Cost B, it subtracts from Cost A opposed to adding, while adding two figures still as normal if they're both 'positive sums'?
So, this is probably a basic math and an easy enough formula (famous last words!) but sometimes our cost is a negative sum due to a buy-back scheme that we operate.
Usually, to work out the cost total would be to add both but when this negative sum is calculated, it should still come off our cost price but instead it adds, it can become easily confusing - as an example.
Cost A - £3,336.00
Cost B is -£56.07
In excel, the total cost is worked out as £3,392.07
> However, it should be £3,279.93
Cost B is variable depending on the buy-back value.
What formula could be used so if it were a negative sum in Cost B, it subtracts from Cost A opposed to adding, while adding two figures still as normal if they're both 'positive sums'?