• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Square meters calculator

Costas

Member
Hi,

I'm trying to set up a square meters calculator where the user would select either mm or feet/inches and enter the length and width in the selected unit of measurement. Is it possible to use the same cells for both mm and ft/inches where the macro will adjust the format of the cells for length and width according to the UOM?

Thanks
Costas
 
Costas

You can select input and output units
upload_2014-8-16_11-25-19.png

See attached:
 

Attachments

  • Area.xlsx
    9.5 KB · Views: 25
Here's my take on the problem, for what it's worth. Debraj's solution is a little more elegant and it works well.
 

Attachments

  • Convert to Square Meters.xlsx
    11 KB · Views: 32
Glad I could help. It was fun working on it, so thanks for posting that kind of problem. If it's math it's in my wheelhouse. I especially like unit conversions and trigonometry problems.
 
Back
Top