Table Math

[john.uhden]

In an AutoCAD table,

B3=67

B4=59

B5=200

B6:

=MAX(0,B3+B4-B5) returns #### when the answer should be 0.

What's strange is that B6 had been formatted as a whole number, but after I entered the formula it changed to text, which might explain the ####, but I can't simply reformat it to a whole number; it's stuck as text.

[JTBWorld · Accepted solution]

MAX is not a supported function. Only Average, Sum and Count. 

[john.uhden]

@JTBWorld
That's disturbing. C3D expressions allow the MAX function.
Somehow I'll have to figure out the answer myself. 😩

[dbroad]

If you find out, let us know. BTW other functions are supported. See 

https://www.cadforum.cz/en/qaID.asp?tip=6381

[JTBWorld]

@dbroad Great! I thought I had used a few like round but forgot where I had that list.