You are invited to Log in or Register a free Frihost Account!

# EXCEL help

Yantaal
i am working on something for my college work a kind of binary calculator nothing special i just want to be able convert stuff easily, i know they have them on the internut but i would lioke to make my own.

but what i want basically is a formula to type in to a cell.

this formula will look at another cell, and if that cell contains an odd number then it will put a 1 in its own cell.

does that make sense?

it would be great if you could help, cheers
Yantaal
Yantaal
allthough my way is rather clumsy if anyone knows anyways i would still like to heeeear it
Nyizsa
This may be what you want:
 Code: =MOD(A1;2)
roninmedia
 Code: =IF(MOD(A1,2)=0, 0, 1)

There you go. That should do it. It checks by dividing the value by two and checking for the remainder. If the remainder is zero, it reads it as even and returns zero. However, if the remainder is not zero, it assumes the number is odd and returns a value of 1.
Nyizsa
roninmedia wrote:
 Code: =IF(MOD(A1,2)=0, 0, 1)

There you go. That should do it. It checks by dividing the value by two and checking for the remainder. If the remainder is zero, it reads it as even and returns zero. However, if the remainder is not zero, it assumes the number is odd and returns a value of 1.

This is an overkill. Why do you check the remainder? The remainder itself is what you want!
Yantaal
thats awesome,. i pretty much did that
only i did it over a series of cels.

cheers guys