+ Reply to Thread
Results 1 to 5 of 5

Caculate the number of trees

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Caculate the number of trees

    Hello everybody
    If I have a land and I need to know the numbers of trees needed to be planted. How can i achieve that?
    The land is ractangular . The legnth of the land is 1000 m and the width is 500 m
    The distance between each tree should be 6 m

    If UDF function the solution would be perfect
    UDFName(Length,Width,Distance)
    Thanks advanced for help
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Caculate the number of trees

    =1000*500/6^2
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Caculate the number of trees

    Thanks Mr. shg for this quick reply
    Is it a rule ? Can you simply exaplain the logical steps of doing that?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Caculate the number of trees

    It's the total area divided by the area occupied per tree.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Caculate the number of trees

    Thanks for simple and useful explain

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 07-15-2014, 02:46 PM
  2. Caculate number of weeks stock
    By dreamer1963 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2014, 07:57 AM
  3. How to caculate the number of cells within the same day?
    By williamkai1989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2013, 07:21 AM
  4. [SOLVED] telephone trees
    By rbj in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-04-2005, 04:05 PM
  5. Forest & Trees????
    By Ken Loomis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1