Re: Negative Numbers To Zero
Firstly, in order to get the answer to F6-D6 you don't need to use Sum, that is =F6-D6 would give you exactly the same answer.
What you can do is use an IF statement that sets the cell value to zero if the answer if less than 0.
Use: =IF(F6-D6<0, 0, F6-D6)
The if statement has three arguments, the first is the condition you want to test (in this case if F6-D6 is less than 0, the second argument is what to do if the condition is true (answer is negative) and the thrid what to do if it is false (answer is positive).
Video Tutorials / Excel Dashboards Reports