FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
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
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
Related topics
can i help?
help,Bonding
HELP!!
Help me with MySQL Account Maintenance and phpBB 2.0.15 :((
Exporting to Excel and formatting textarea
from excel to php ?
[help] Pregunta sobre Microsoft Excel
Applying for job: Please help
Saving excel from email attachment (HELP)
good MS EXCEL site?
Export Image to Excel
MS Office XP re-install asking for help on SP 2, maybe SP 3
Excel slow to start if I double-clisk on a file
How to parse excel?
Reply to topic    Frihost Forum Index -> Computers -> Software

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