Topic: Mathmatical Formula's in Tables - Help

[AVCAD]

So I have a table I am trying to use to do some calculations. I Have the correct formula but autocad wont do it. It works in excel but I need it in cad

=(2*(B12-B13)*TAN(B11/2)/12)

I think the problem is the TANGENT ... does autocad not allow this?

Thanks in advance

[mjfarrell]

does this offer any hint?

You can add formulas to a table, so that it automatically calculates the following:

Sum
Average
Count (counts the cells in a column or row)
Cell (displays the value of another cell)
Equation (lets you manually insert a formula)

[Lee Mac]

Try the following:

Code: [Select]

=(2*(B12-B13)*tang(B11/2)/12)

[AVCAD]

Thanks Lee. That worked.

[Lee Mac]

Good stuff - you're welcome.

( Here is a complete reference )

[Mark]

does this offer any hint?

FYI

http://exchange.autodesk.com/autocad/enu/online-help/ACDLT/2012/ENU/pages/WS1a9193826455f5ffa23ce210c4a30acaf-4d44.htm

[AVCAD]

Awesome! I didn't find that before Thanks.

Can you do IF statements? Cant seem to get that work either

=IF(B11=2,0,ROUND(E11/(B15*C13)))

[Lee Mac]

Can you do IF statements? Cant seem to get that work either

Unfortunately not as far as I know.

[ChrisCarlson]

Tables in CAD are terrible, if you need more advanced functions you will need to look at using Excel in the background.

[Stefan]

Awesome! I didn't find that before Thanks.

Can you do IF statements? Cant seem to get that work either

=IF(B11=2,0,ROUND(E11/(B15*C13)))

You can try this trick

Code: [Select]

=(1-abs(2-B11)^0)*ROUND(E11/(B15*C13))

[Lee Mac]

I'm quite surprised 0^0 doesn't error 

Nice trick Stefan - though, shouldn't it be:

Code: [Select]

=(abs(2-B11)^0)*ROUND(E11/(B15*C13))

[Stefan]

I'm quite surprised 0^0 doesn't error 

Yes, it was a surprise for me too. Any other program will give you an error.

Nice trick Stefan - though, shouldn't it be:

Code: [Select]

=(abs(2-B11)^0)*ROUND(E11/(B15*C13))

Looking again at the request, yes, your formula is the correct one...

[AVCAD]

You guys are way smarter than me.

Thanks it worked perfectly!