Software

Ask something
Discussion Locked

Formula in Word

0 helpful
3 replies

by abailey101

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a Word form that I have inserted formula's in a table that divide two cells (=c3/c2). The formula works, however, if there is no numbers in either cell c3 or c2 i get a !zero divide error. Can someone tell me how not to display this error message. When C3 and C2 have data the formula works fine.

3 replies

by nikki96

Try this formula.
It only divides if C2 is a number that is not 0. Otherwise, it makes the cell 0.

IF(INT(C2)<>0,C3/C2,0)

HTH
~nikki~

This discussion is closed to new replies.