FRIHOST • FORUMS • FAQ • TOS • BLOGS • DIRECTORY
You are invited to Log in or Register a Frihost Account!

EXCEL help

   Frihost Forum Index -> Computers -> Software
 


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
i sussed it never mind chaps, sorry to waste your time reading this thread
Yantaal
allthough my way is rather clumsy if anyone knows anyways i would still like to heeeear it Smile
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. Cool
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. Cool

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
Reply to topic    Frihost Forum Index -> Computers -> Software

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2007 Frihost, forums powered by phpBB.