Sure!

In B1 enter:

=(A1=1)*100

So if A1 contains 1, B1 will equate to 100.

That answers your question ... BUT ... I'll bet that's not what you're
looking for.

How about being more specific with your question.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jmj713" wrote in message
...
Is it possible to have Excel automatically fill cells with certain data in
one column based on data in another column?