User guide

Each property is calculated using the “best available” method. If the cell reference argument does not point to a valid
structure cell, #N/A appears in the cell.
All ChemDraw/Excel functions are described below.
Chemical name
Displays systematic names for chemical structures with support for the Cahn-Ingold-Prelog rules for ster-
eochemistry.
Function
CFW_CHEMICAL_NAME(cell ref)
Example
In cell: =CFW_CHEMICAL_NAME(A2)
Result: 1-(2,3-dihydro-1H-inden-2-yl)propan-2-one
Note: Some PerkinElmer Informatics product packages and levels allow unlimited structure-to-name con-
versions, while others impose a daily limit.
Chemical composition
When this function is called with just a cell reference, it displays the elemental percent by weight for all elements in
the structure. When this function is called with a cell reference and an atomic symbol, it displays the fraction by
weight of the given element in the structure.
Functions
CHEM_COMPOSITION(cell ref)
CHEM_COMPOSITION(cell ref, atomic symbol)
Examples
In cell: =CHEM_COMPOSITION(A2)
Result: C,82.72;H,8.10;O,9.18
In cell: =CHEM_COMPOSITION(A2, "C")
Result: 0.827188133
Chemical formula
Displays the chemical formula for the structure(s) in the cell.
Functions
CHEM_FORMULA(cell ref)
CHEMPROPSTD_MOL_FORMULA(cell ref)
Examples
In cell: =CHEM_FORMULA(A2)
Result: C12H14O
In cell: =CHEMPROPSTD_MOL_FORMULA(A2)
Result: C12H14O
ChemBioDraw 13.0
Chapter 10: ChemDraw/Excel 166 of 401