I am creating a subnet calculator. Binary math. My calculation involves block sizes of 2 to x power. Block size of 2,4,8…128,256. I am doing my work in a column. When the value reaches 256, I need to reset it to 0. The current cell contains previous cell value plus the (absolute value) block size. I.E. =E17+$E$2 (=240+16).

What I need is a formula that if the value = 256 to reset to 0.

Thanks in advance for your assistance.

What I need is a formula that if the value = 256 to reset to 0.

Thanks in advance for your assistance.

Last edited: