Using JChem Excel FunctionsBack to index page
Most of JChem for Excel functions require a structure as an input. The functions can be reached by opening the function wizard and also by entering the name of the function and related parameters to the cells.
Please, note that there is a short description for each function argument, but JChem for Excel's online help is also available here.
JChem for Excel functions are available from the cells as well, like other MS Excel functions. In this case, select a cell, enter the name of a function, and the necessary parameters (cell address containing a structure). e.g.: =JCExactMass(A4)
NOTE: Atom Numbers
A lot of JChem for Excel functions, which require atom numbers as input, these can be displayed with JCAtomNumberImage functions. If you would like to apply these numbers in further calculations, you should start numbering from zero, which means that the atom numbers displayed with JCAtomNumberImage function have to be reduced with 1.
NOTE: Structure Drawing Behaviour - Excel Dialogs
In special cases when Excel dialogs are visible, e.g. editing function arguments with cross-references to other worksheets it is advised to switch-off structure drawing possibilities in Options (see the details here).