+ Reply to Thread
Results 1 to 7 of 7

Formula Calculate area & perimeter for multiple columns

  1. 11-06-2014, 12:48 AM #1
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Formula Calculate area & perimeter for multiple columns

    Hi,

    I am searching a formula to calculate the area & Perimeter

    The problem is i have data from column D to DC , for various dimensions

    Thanks in Advance
    Punnam
    Attached Files Attached Files
    Last edited by Punnam; 11-06-2014 at 01:14 AM.
    Reply With QuoteRegister To Reply
  2. 11-06-2014, 02:20 AM #2
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Formula Calculate area & perimeter for multiple columns

    Hi Punnam,

    in column DD you could test:


    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Cheers
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 11-06-2014, 02:24 AM #3
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Formula Calculate area & perimeter for multiple columns

    canapone

    First Thanks for interest
    i tried it is showing "#VALUE!"

    Punnam
    Reply With QuoteRegister To Reply
  4. 11-06-2014, 02:29 AM #4
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Formula Calculate area & perimeter for multiple columns

    canapone

    Wow it is working fine
    I made a mistake in copying the formula
    thank for the help my friend
    Any idea about to get perimeter

    Punnam
    Reply With QuoteRegister To Reply
  5. 11-06-2014, 02:32 AM #5
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Formula Calculate area & perimeter for multiple columns

    Hi again,

    in DE5 (please make some test)

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Regards
    Reply With QuoteRegister To Reply
  6. 11-06-2014, 02:40 AM #6
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Formula Calculate area & perimeter for multiple columns

    Quote Originally Posted by canapone View Post
    Hi again,

    in DE5 (please make some test)

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Regards
    Hi Canapone,
    Yes it is working
    Thank you
    Punnam
    Reply With QuoteRegister To Reply
  7. 11-06-2014, 03:07 AM #7
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Formula Calculate area & perimeter for multiple columns

    Hi Punnam,

    you're welcome: thanks for providing feedback.

    Cheers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula for Replacing Codes Indicating Geographic Area with Actual Name of Area
    By andywozhere in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2012, 08:53 AM
  2. Area Formula?: eg how many 90mm x 50mm stickers would fit in a 1m x 600mm area
    By kingpinnz in forum Excel General
    Replies: 1
    Last Post: 10-31-2011, 09:08 PM
  3. How to calculate the area under a trendline
    By Jessica.Bush in forum Excel General
    Replies: 1
    Last Post: 08-17-2010, 04:06 AM
  4. Solver query: Minimum rectangle perimeter
    By svik in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2009, 04:28 PM
  5. How do I find max/min around the perimeter of a spud plot?
    By Hermonator in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2006, 03:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1