Hello Community!

This Saturday, April 11, from 9am – 1pm EDT we will be performing maintenance on the Vectorworks Community Board. During this time, the site will be unavailable.

Member

2

2 Neutral

• Rank
Greenhorn

• Location
Australia

## Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

1. ## If Function in worksheets

@michaelk I think you are generous to say that I was close! @MullinRJ I have copied your third solution (like a trained monkey, haha) with great success! I appreciate the explanations and various examples, these help me (slowly) understand the greater principles and commands. Thanks both of you for taking the time to post your replies, I am gratefully standing on your shoulders! I have another question, but will digest and play around for a bit before coming back, I don't fully understand all the commands and process yet and need a bit of time to play around.
2. ## If Function in worksheets

Hi Everyone, I am trying to build a worksheet to calculate landscape area (Australian CDC regulations). For landscaping their is a requirement for water permeable area or 'Landscaped Area' It is a percentage of the total site area determined by lot size: 200- 300m2 10% Landscape Area 300- 450m2 15% Landscape Area 450- 600m2 20% Landscape Area 600- 900m2 30% Landscape Area 900- 500m2 40% Landscape Area 1500m2 + 45% I have created a database line to get the site area from a class. The formula I am having trouble with needs to determine an 'IF' function, something ; like: =IF(C7=>600) and (C7<90) (C7*0.3)

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×

• KBASE
• #### MARIONETTE

×
• Create New...