When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

For showing a 0 value in place of error, use =IFERROR(B2/C2,0) You can also use an IF statement like =IF(C2=0,0,B2/C2) to get 0 return value in case C2 contains a zero.