Question description:
This user has given permission to use the problem statement for this
blog.
Hello. I would like to create a drop down option to choose Square Feet or Square Meters. Next column they insert the amount and the next it converts the value to whatever is chosen from the drop down option.
Can you help please?
Solved by Z. Q. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
23/10/2017 - 11:30
Hello! Thanks for choosing Got It Pro-Excel.
Excelchat Expert
23/10/2017 - 11:31
i'M SO GLAD TO SUPPORT YOU TODAY ABOUT YOUR DROPDOWN LIST
Excelchat Expert
23/10/2017 - 11:31
Helloo
Excelchat Expert
23/10/2017 - 11:32
in session
User
23/10/2017 - 11:33
thanks
Excelchat Expert
23/10/2017 - 11:33
you're welcome
Excelchat Expert
23/10/2017 - 11:33
Would you mine to share with us the file containing about the Square feet or square meters?
Excelchat Expert
23/10/2017 - 11:33
In this way, we could support you to create the dropdown list
User
23/10/2017 - 11:34
I haven't got a file. I know how to create a drop down list
User
23/10/2017 - 11:34
i want to create a drop down option..Square feet & square Meters
User
23/10/2017 - 11:34
next cell hey insert the mount
User
23/10/2017 - 11:35
the following cells returns a value
Excelchat Expert
23/10/2017 - 11:35
Yes, Got it. But, I hope to see your references for the computation
Excelchat Expert
23/10/2017 - 11:36
We must set up the values for each square feet or Square meters
Excelchat Expert
23/10/2017 - 11:36
can you give us the formula, so we could create this for you?
Excelchat Expert
23/10/2017 - 11:38
Alright, I'm going to create this for you using Excel on my desktop then upload the file for you.
Excelchat Expert
23/10/2017 - 11:38
is this works for you?
User
23/10/2017 - 11:38
sure does
Excelchat Expert
23/10/2017 - 11:38
thank you.
Excelchat Expert
23/10/2017 - 11:38
please give me few moment for this
Excelchat Expert
23/10/2017 - 11:41
Once a person input a number in , example. 2 , what will be your expected result?
User
23/10/2017 - 11:43
example - i choose square feet from the drop down menu. I insert 500 in the next cell
User
23/10/2017 - 11:43
i want excel to automatically convert to sqm
User
23/10/2017 - 11:44
and visa versa
Excelchat Expert
23/10/2017 - 11:44
alright, do you have any idea how many feet in 1 meter?
Excelchat Expert
23/10/2017 - 11:45
Just searching it, for a moment
User
23/10/2017 - 11:45
we use the number as a whole..so if i insert 500 sq meters i times it by 10.7639104
User
23/10/2017 - 11:46
if i insert 10,000 i divide by 10.7639104
User
23/10/2017 - 11:46
10,000 sq ft*
Excelchat Expert
23/10/2017 - 11:47
okay, thanks
Excelchat Expert
23/10/2017 - 11:47
I'm creating it, please extend our time
Excelchat Expert
23/10/2017 - 12:01
https://www.dropbox.com/s/i5mcclmrbuzfstf/convert%20ft%20to%20meter%20in%20a%20dropdown%20list.xlsx?dl=0
Excelchat Expert
23/10/2017 - 12:02
Please download my dropbox file and check. Hope it works.
Excelchat Expert
23/10/2017 - 12:04
hello
Excelchat Expert
23/10/2017 - 12:08
hello there
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
