×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Table Equation

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

sldwkmin,

From my experience with using them, I would have to say no.  Hopefully someone will prove me wrong.

SA

RE: Table Equation

If it's an Excel BOM, prefix whichever cell reference you want to "fix" with $. (e.g. $H41 or H$41 or $H$41)

cheers
SW07-SP3

RE: Table Equation

(OP)
Not an Excel BOM.  Using a SolidWorks Table BOM.

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

Are you referencing cells which are not in the same row as the equation?

cheers
SW07-SP3

RE: Table Equation

(OP)
No, The cell the equation is referencing is in the same row.

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

If you are only referencing cells within the same row, you can set the equation in the header cell (title) using the other column titles instead of cell references.

cheers
SW07-SP3

RE: Table Equation

(OP)
The column header for my cell H41 is "Total Surface" I've tried entering it as just Total Surface, 'Total Surface' and (Total Surface) within the equation.  With any of those entries the equation does not properly calculate.  Do I need brackets around the text of some sort or what am I doing wrong?

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

(OP)
Added Note:  The equation is only in the final row of the BOM.  The equation is not used for the entire column.  Just the very bottom cell in the column.

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

When setting the columns header to an equation it seems to work better if the Equation Editor is used to select the title from the drop-down list, and the = prefix is added automatically. If typing the equation directly into the cell, you need to add the = prefix.

I haven't had any success creating a relative/dynamic reference to a cell in just the last cell.

cheers
SW07-SP3

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources