K
kwrohde
does excel recognize units? If so which ones? Is there a good way t
define them yourself? thank
define them yourself? thank
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
maybe it's just me but what do you mean with 'units' ?
maybe it's just me but what do you mean with 'units' ?
G
Gord Dibben
Frank
It's not "just you".
Gord
It's not "just you".
Gord
F
Frank Kabel
Hi Gord
thanks. I thought it was some US specific measurement
thanks. I thought it was some US specific measurement
R
RagDyer
Hey Guys,
Don't tell me Canada and Germany don't have units of length, volume,
temperature or currency.<g>
--
Regards,
RD
Don't tell me Canada and Germany don't have units of length, volume,
temperature or currency.<g>
--
Regards,
RD
N
Norman Harker
Hi kwrohde!
Excel recognises numbers. It is for you to define what those numbers
are. There's no automatic assumption of metric or Imperial and even
the currency symbol is based upon your computer's regional settings.
You can use the CONVERT function to convert between various unit
types. See the very extensive Help file on CONVERT as there is a lot
of useful stuff in it.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Excel recognises numbers. It is for you to define what those numbers
are. There's no automatic assumption of metric or Imperial and even
the currency symbol is based upon your computer's regional settings.
You can use the CONVERT function to convert between various unit
types. See the very extensive Help file on CONVERT as there is a lot
of useful stuff in it.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
F
Frank Kabel
lol
at least the use the metric system ;-)
at least the use the metric system ;-)
D
Dana DeLouis
Is there a good way to define them yourself?
Like others have mentioned, Excel can not work well with Units like a
dedicated Math program like Mathematica. Excel can not keep track of
numeric, and a separate symbolic units.
One poor-mans way to do something like this would be to use Range Named
constants. It depends on what you are doing of course. If you wanted to
work in hours, here is a small example. It is not the best idea, but it may
give you some ideas for your situation.
Sub Demo()
ActiveWorkbook.Names.Add Name:="miles", RefersTo:="=1"
ActiveWorkbook.Names.Add Name:="hour", RefersTo:="=1"
'1 Hour = 60 Minutes
ActiveWorkbook.Names.Add Name:="minutes", RefersTo:="=hour / 60"
[A1].Formula = "=60*miles / hour"
[B1].Formula = "=2*hour"
' Or...
[B1].Formula = "=120*minutes"
[C1].Formula = "=A1*B1"
End Sub
Like others have mentioned, Excel can not work well with Units like a
dedicated Math program like Mathematica. Excel can not keep track of
numeric, and a separate symbolic units.
One poor-mans way to do something like this would be to use Range Named
constants. It depends on what you are doing of course. If you wanted to
work in hours, here is a small example. It is not the best idea, but it may
give you some ideas for your situation.
Sub Demo()
ActiveWorkbook.Names.Add Name:="miles", RefersTo:="=1"
ActiveWorkbook.Names.Add Name:="hour", RefersTo:="=1"
'1 Hour = 60 Minutes
ActiveWorkbook.Names.Add Name:="minutes", RefersTo:="=hour / 60"
[A1].Formula = "=60*miles / hour"
[B1].Formula = "=2*hour"
' Or...
[B1].Formula = "=120*minutes"
[C1].Formula = "=A1*B1"
End Sub