I have a Col A of numbers. I want the result in Col B to return the value if
it can be fully divided by a certain number, e.g. 5, or else return a zero.
Does anybody know what should be the formula in Col B to get those results?

Col A Col B
------ ------
23 0
45 9
12 0
16 0
25 5

=IF(MOD(A2,5),0,A2/5)
--
David Biddulph

"EK" wrote in message
...
I have a Col A of numbers. I want the result in Col B to return the value
if
it can be fully divided by a certain number, e.g. 5, or else return a
zero.
Does anybody know what should be the formula in Col B to get those
results?

Col A Col B
------ ------
23 0
45 9
12 0
16 0
25 5

"EK" wrote:

I have a Col A of numbers. I want the result in Col B to return the value if
it can be fully divided by a certain number, e.g. 5, or else return a zero.
Does anybody know what should be the formula in Col B to get those results?

Col A Col B
------ ------
23 0
45 9
12 0
16 0
25 5

YOU CAN USE BELOW MENTIONED FORMULA

=IF(MOD(A2,5)=0,A2/5,0)

H S SHASTRI

INDIA