Results 1 to 6 of 6

Thread: IF Statements in Table Formula

  1. #1
    Design Visualization Moderator stusic's Avatar
    Join Date
    2004-10
    Location
    Denver, Colorado
    Posts
    1,515
    Login to Give a bone
    0

    Question IF Statements in Table Formula

    Just to be sure: one cannot use a conditional IF statement in a formula in Autocad. Correct? I'm on 2011, maybe it's possible in a newer version? Does anyone know of a workaround that doesn't involve a data link or xls2cad?

    Thanks!

  2. #2
    100 Club
    Join Date
    2015-10
    Posts
    158
    Login to Give a bone
    0

    Default Re: IF Statements in Table Formula

    Kinda incorrect, but substantially correct. You can use "if" logic with Diesel statements; but any fields you try to put inside of a Diesel statement are turned into plain text at whatever the field's current value is.

    If I am incorrect in this, someone please let me know!

  3. #3
    Design Visualization Moderator stusic's Avatar
    Join Date
    2004-10
    Location
    Denver, Colorado
    Posts
    1,515
    Login to Give a bone
    0

    Default Re: IF Statements in Table Formula

    Okay, since I just want to reference table cells and not using fields, this might work. I don't know much about diesel expressions aside from what I see when creating a field, so I'm going to need to research that part further and see how it works in practice. Thanks for your help

  4. #4
    Design Visualization Moderator stusic's Avatar
    Join Date
    2004-10
    Location
    Denver, Colorado
    Posts
    1,515
    Login to Give a bone
    0

    Default Re: IF Statements in Table Formula

    Quote Originally Posted by StDoodle View Post
    You can use "if" logic with Diesel statements; but any fields you try to put inside of a Diesel statement are turned into plain text at whatever the field's current value is.
    I've created the IF statement in a diesel expression, but I'm beginning to think you aren't able to reference a table cell in diesel...

  5. #5
    100 Club
    Join Date
    2015-10
    Posts
    158
    Login to Give a bone
    0

    Default Re: IF Statements in Table Formula

    Didn't catch that you were talking about tables, sorry. But yeah, I've tried the exact same thing before and gave up; just wasn't worth it.

    Though, if your "if" statements are simple enough and deal only with numbers, you could probably change them into formulas that would work.

    Honestly, your best bet is probably to set all of that up in Excel and link it. If, like me, you don't have Excel... the best bet is probably to get a second job and use the money to buy a copy, 'cause work sure as hell won't be taking care of it...

  6. #6
    Design Visualization Moderator stusic's Avatar
    Join Date
    2004-10
    Location
    Denver, Colorado
    Posts
    1,515
    Login to Give a bone
    0

    Default Re: IF Statements in Table Formula

    Yeah, I was trying to avoid creating yet another file... It seems like conditionals in formulas would be something that would be a no-brainer for Autodesk... Oh well, back to square one. Thanks for your help

Similar Threads

  1. Roundup in table formula?
    By eamon.fleming in forum AutoCAD Tables
    Replies: 1
    Last Post: 2011-11-18, 02:35 PM
  2. 2 table/formula questions
    By tyeelaw13 in forum AutoCAD General
    Replies: 4
    Last Post: 2009-12-09, 10:26 PM
  3. Table Formula...
    By BeKirra in forum AutoCAD Tables
    Replies: 2
    Last Post: 2009-06-24, 02:26 AM
  4. Formula property in schedule table.
    By arcadia_x27 in forum ACA General
    Replies: 8
    Last Post: 2007-08-20, 03:25 AM
  5. Table Formula Formats
    By red2002yzfr1 in forum AutoCAD Tables
    Replies: 1
    Last Post: 2005-10-07, 11:27 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •