View Single Post
  #2   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

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.

:)