I am looking for an add in or macro in Excel that creates a function
that will take a chemical formula as the argument and return the
molecular weight.  E.g. =CHEMWT(H2O)  returns "18".  I have so far
only managed to fins one and it didn't run under the latest version of
Excel.

---

Clarification of Question by tday01-ga on 03 Jul 2006 12:08 PDT

Unfortunately, i deleted the one I found and can't find it again.  It
claimed to run under '97 Mac.  I am running Excel 2003 under Windows
XP.

---

Request for Question Clarification by hummer-ga on 03 Jul 2006 13:02 PDT

Hi tday01,

Is this suitable?

MwCalc 
Molecular Weight Calculator 
A free add-in for spreadsheets 
"ChemicaLogic's Molecular Weight Calculator is a free add-in for
spreadsheets that you can use to calculate the molecular weight of
chemicals. This handy function takes a single string argument which is
the chemical formula (or a cell reference containing the chemical
formula) and returns the molecular weight.
No more looking up molecular weights! Download now. Molecular weight
calculator is available for:
? Excel 95/97/2000/XP for Windows 95/98/NT4/XP" 
http://www.chemicalogic.com/mwcalc/
or
http://64.233.167.104/search?q=cache:VcVz0Pi8ctMJ:www.chemicalogic.com/mwcalc/+xp+excel+calculate+molecular+weight+of+chemicals&hl=en&gl=ca&ct=clnk&cd=1&client=firefox-a

Regards,
hummer

---

Clarification of Question by tday01-ga on 04 Jul 2006 16:28 PDT

Hi Hummer0ga,

This one looks perfect, but for the life of me I can't download it. 
This page behaves as if it is itself a downloadable file.  Can you
download this add-in?

Tony

---

Request for Question Clarification by hummer-ga on 04 Jul 2006 17:02 PDT

Hi Tony,

I found it a bit weird too, I was hoping it would work for you. I'm
reluctant to do any testing here because I'm on an old computer
(1998!) and dial-up. Maybe one of these will work?

MW Calc v1.3
http://www.the-gibson-family.co.uk/software/mwcalc/mwcalc.html

MW Calc 6.0.1
http://www.tucows.com/get/34675_20428

Molecular Weight Calc 4.6
http://www.tucows.com/get/33301_20358

MWCalc
http://sourceforge.net/projects/mwcalc/

Good luck!
hummer

---

Clarification of Question by tday01-ga on 14 Jul 2006 14:37 PDT

That's great.  I tried the download with Explorer and it worked fine.
The function works.  Hummer-GA you can claim your $5.  And thanks to
eestudent for finding the weird FireFox bug.

Tony

Hi Tony,

Thank you for giving me the opportunity to post my answer, I
appreciate it.  Funny the weirdness turned out to be Firefox (thank
you,  eestudent!), who would've thought? Here it is again to make it
official -

MwCalc 
Molecular Weight Calculator 
A free add-in for spreadsheets 
"ChemicaLogic's Molecular Weight Calculator is a free add-in for
spreadsheets that you can use to calculate the molecular weight of
chemicals. This handy function takes a single string argument which is
the chemical formula (or a cell reference containing the chemical
formula) and returns the molecular weight.
No more looking up molecular weights! Download now. Molecular weight
calculator is available for:
? Excel 95/97/2000/XP for Windows 95/98/NT4/XP" 
http://www.chemicalogic.com/mwcalc/

Happy calculating,
hummer

It would help if you tell us which one you already found, so we don't
look at the same one.

- Hammer

The website cannot be opened with Firefox. Try IE. I have never seen this before.