It seems you have Hijacked another discussion thead (begun by Nihal on Feb 5,
2011)
If you wish to begin a new query, please start your own topic.
Especially as this has absolutely nothing to do with passing variables to
functions!
Paul
________________________________
From: Srinivasulu Reddy Yarasi <seenuyar...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Thu, February 10, 2011 9:14:09 PM
Subject: Re: $$Excel-Macros$$ Passing Variable to another function
Hi Manhar,
Use the following formula,
=LEFT(C3,FIND("'",C3,1)-1)+VALUE(MID(C3,FIND("'",C3,1)+1,FIND("""",C3,1)-FIND("'",C3,1)-1))/12
Above formula is for the value entered in Inches in cell C3 and always the
value
is expected in Feet(') and Inches("), the forumula also ignores the multiple
spaces beteem the Feet and Inches value.
Attaches is the ssheet with solution formula filled with yellow colour.
Regards
SeenuYarasi
On Thu, Feb 10, 2011 at 12:21 PM, manhar prajapati <prajapati.man...@gmail.com>
wrote:
Dear All
>I require your urgent help for attach file.
>
>Please find attach file for calculation of Square meter form Inches to
>Centimeter.
>I want to a formula which convert inches in to Centimeter.
>Example
>10' 3'' is equal to 10.25 for Calculation of Square Feet.
>Thanks and regards
>Manhar Prajapati
>--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
