I need a formula that does two things:
- Checks to see if the inputted value is 0
- If that value is not 0, then checks to see if that inputted value divides cleanly by 13.
Here's what I have, and it is not accepting 0. Any help/direction would be appreciated.
=IF(M10<1, 0, if(MOD(M10/13,1)=0,M10,0))