Table Equation
Table Equation
(OP)
The following equation is used in a cell in a BOM. ({2}0.012*H41 "Gallons") H41 represents a cell. If items are added to the BOM or items removed the equation no longer references the correct cell. Is there a way to make the cell reference dynanmic in place of static?
Cole M
CSWP, CSWST, CSWI, CPDM
SW06
SW07
IBM T42p, 2g proc., 1g RAM,ATI Mobility Fire GL T2
HP XW4100, 3g proc., 3g RAM, Nvidia Quadro 980 XGL
HP XW4300, 3.4g proc, 2.5g RAM, ATI Fire GL 3100






RE: Table Equation
From my experience with using them, I would have to say no. Hopefully someone will prove me wrong.
SA
RE: Table Equation
SW07-SP3
RE: Table Equation
Cole M
CSWP, CSWST, CSWI, CPDM
SW06
SW07
IBM T42p, 2g proc., 1g RAM,ATI Mobility Fire GL T2
HP XW4100, 3g proc., 3g RAM, Nvidia Quadro 980 XGL
HP XW4300, 3.4g proc, 2.5g RAM, ATI Fire GL 3100
RE: Table Equation
SW07-SP3
RE: Table Equation
Cole M
CSWP, CSWST, CSWI, CPDM
SW06
SW07
IBM T42p, 2g proc., 1g RAM,ATI Mobility Fire GL T2
HP XW4100, 3g proc., 3g RAM, Nvidia Quadro 980 XGL
HP XW4300, 3.4g proc, 2.5g RAM, ATI Fire GL 3100
RE: Table Equation
SW07-SP3
RE: Table Equation
Cole M
CSWP, CSWST, CSWI, CPDM
SW06
SW07
IBM T42p, 2g proc., 1g RAM,ATI Mobility Fire GL T2
HP XW4100, 3g proc., 3g RAM, Nvidia Quadro 980 XGL
HP XW4300, 3.4g proc, 2.5g RAM, ATI Fire GL 3100
RE: Table Equation
Cole M
CSWP, CSWST, CSWI, CPDM
SW06
SW07
IBM T42p, 2g proc., 1g RAM,ATI Mobility Fire GL T2
HP XW4100, 3g proc., 3g RAM, Nvidia Quadro 980 XGL
HP XW4300, 3.4g proc, 2.5g RAM, ATI Fire GL 3100
RE: Table Equation
I haven't had any success creating a relative/dynamic reference to a cell in just the last cell.
SW07-SP3