Please would you be able to help with adding into a current formula if the result is less than 0 then show 0.
The current formula is =(N2-3)/SUMIF('Sum of Digit'!A:B,N2,'Sum of Digit'!B:B)*M2. I believe that it is something like =if(<0,0) but am not sure how to add it into the formula. Any help would be appreciated.
The current formula is =(N2-3)/SUMIF('Sum of Digit'!A:B,N2,'Sum of Digit'!B:B)*M2. I believe that it is something like =if(<0,0) but am not sure how to add it into the formula. Any help would be appreciated.