TABLE FUNCTION

[grobnik]

Hi to everybody,

I'm asking a question to this forum about table function.

I'm searching a function like EXCEL IF, I mean:

- I have a table with 3 cells, the first contain a calculation value (numeric), the second contain a comparison value, in the third should contain a word "TRUE" or "FALSE" if calculated value is greater or lower than comparison value.

Is there a standard autocad function able to do this ?

I have a lot of drawings containg data.

[devitg]

@grobnik Please upload your sample.dwg 

[calderg1000]

Regards @grobnik 

Try this code, Read the table data from row number 2.

;;;___
(defun c:Val_Tab (/ table nrows vals row column tx1 tx2)
  (setq
    table (vlax-ename->vla-object (car (entsel)))
    nrows (vlax-get-property table 'rows)
    row	  1
  )
  (repeat (1- nrows)
    (setq column 0
	  tx1	 (vlax-invoke-method table 'GetText row column)
	  tx2	 (vlax-invoke-method table 'GetText row (1+ column))
    )
    (if	(> (atof tx1) (atof tx2))
  	    (vla-settext table row (+ 2 column) "TRUE")
        (vla-settext table row (+ 2 column) "FALSE")
    (setq row (1+ row))
  )
  (princ)
)

,  

[Sea-Haven]

As the If is only a true or false no need for progn, (if (>, like me thinking to far ahead some times.

[calderg1000]

It's true, he corrected himself. Thank you so much

[Sea-Haven]

OOps

(if	(> (atof tx1) (atof tx2))
  	    (vla-settext table row (+ 2 column) "TRUE")
        (vla-settext table row (+ 2 column) "FALSE")
    (setq row (1+ row))
  )
should be 
(if  (> (atof tx1) (atof tx2))
  (vla-settext table row (+ 2 column) "TRUE")
  (vla-settext table row (+ 2 column) "FALSE")
)
    (setq row (1+ row))
)