View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default calculate moles in excel

Ken,

Interesting point. There are probably as many references to Avagadro as
Avogadro on the net and in textbooks but what we can agree on completely is
that it isn't avagardo and a man of such eminence; at the very least,
deserves his name to be spelt with a capital A.

Mike


"Ken Johnson" wrote:

On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca wrote:
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.


:)


But it's Avogadro.

Ken Johnson