Search the Community
Showing results for tags 'worksheet function'.
Found 5 results
-
The ability to make changes to the (sub)cell visual style; font, colour, fill, based on a pre-set condition. This could be an extension of the ability to individually alter the cells of a datarow, instead of a whole column that follows the change in graphic style.- 1 reply
-
- 3
-
-
- worksheet data
- worksheet function
- (and 3 more)
-
I'm working on an energy code worksheet and having trouble working out the if-then statement function: Basically, I want the worksheet to automatically say how many credits I need based on the area of the building. The area is shown in cell C1. In cell D3 I would like a formula that says: if the value in cell C1 is less than 1500 then display 5 (if the area is less than 1500 sq ft we need 5 energy credits), if the value is between 1500 and 5000 then display 8 (we need 8 credits for a 1500 - 5000 area), if the value is greater than 5000 then display 9 (for 5000 or greater areas we need 9 credits). I started with the if((logical_test), value_if_true,value_if_false) syntax: =if((C1=<1500), 5,0) but I'm definitely getting something wrong, it just shows the formula instead of a result. Does anyone know where I'm going wrong? Thanks, Kit
-
Where do I find the Hinge Qty record?
-
Performing math on Spreadsheet and Database cells in a worksheet
Bill Treen posted a question in Troubleshooting
I have a worksheet for calculating roof height. Roof height is based on the weighted average of the individual roof areas relative to a geodetic height. In this worksheet, I have a database cell that picks up polygons that are linked to a record. The next column lists the areas of those polygons. I now have a nice list of the polygons, their names and their areas. In the next column I want to perform a division function where the individual areas are divided by the total area. Since the total area shows up in the column header. I can link a spreadsheet cell to this column header and the total area shows up in the spreadsheet cell. ie. same value HOWEVER, When I then try to divide the spreadsheet cell area by the database header value (to get the weighted average) the spreadsheet cell changes it value to zero and the operation fails. Is there a way to get information from a database cell and perform a math function on it without ruining the value of that cell? -
Been looking for some definitive info on vectorworks.net and a bit of googling too. Thought I'd just ask instead. Are custom worksheet functions that you call using the RUNSCRIPT() worksheet function excluded from Fundamentals??? Conrad
