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
    N32° 32' 19.08", W-84° 52' 59.03"
    Posts
    1,272

    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!
    Phillip Bradshaw
    Lead Pixel Pusher, Lucid Design Studio
    CAD Administrator, Heatcraft RPD

    A doctor can bury his mistakes but an architect can only advise his clients to plant vines. - Frank Lloyd Wright

  2. #2
    100 Club StDoodle's Avatar
    Join Date
    2008-01
    Posts
    129

    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!
    2012-02-24: Finally got around to installing my home copy of AutoCAD... no longer relying on my horrible memory for "how-to" advice!

  3. #3
    Design Visualization Moderator stusic's Avatar
    Join Date
    2004-10
    Location
    N32° 32' 19.08", W-84° 52' 59.03"
    Posts
    1,272

    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
    Phillip Bradshaw
    Lead Pixel Pusher, Lucid Design Studio
    CAD Administrator, Heatcraft RPD

    A doctor can bury his mistakes but an architect can only advise his clients to plant vines. - Frank Lloyd Wright

  4. #4
    Design Visualization Moderator stusic's Avatar
    Join Date
    2004-10
    Location
    N32° 32' 19.08", W-84° 52' 59.03"
    Posts
    1,272

    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...
    Phillip Bradshaw
    Lead Pixel Pusher, Lucid Design Studio
    CAD Administrator, Heatcraft RPD

    A doctor can bury his mistakes but an architect can only advise his clients to plant vines. - Frank Lloyd Wright

  5. #5
    100 Club StDoodle's Avatar
    Join Date
    2008-01
    Posts
    129

    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...
    2012-02-24: Finally got around to installing my home copy of AutoCAD... no longer relying on my horrible memory for "how-to" advice!

  6. #6
    Design Visualization Moderator stusic's Avatar
    Join Date
    2004-10
    Location
    N32° 32' 19.08", W-84° 52' 59.03"
    Posts
    1,272

    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
    Phillip Bradshaw
    Lead Pixel Pusher, Lucid Design Studio
    CAD Administrator, Heatcraft RPD

    A doctor can bury his mistakes but an architect can only advise his clients to plant vines. - Frank Lloyd Wright

Similar Threads

  1. Roundup in table formula?
    By eamon.fleming in forum AutoCAD Tables
    Replies: 1
    Last Post: 2011-11-18, 01:35 PM
  2. 2 table/formula questions
    By tyeelaw13 in forum AutoCAD General
    Replies: 4
    Last Post: 2009-12-09, 09:26 PM
  3. Table Formula...
    By BeKirra in forum AutoCAD Tables
    Replies: 2
    Last Post: 2009-06-24, 02:26 AM
  4. 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
  •