The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"


Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave wrote:

OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)