Thread
:
FORMULA HELP
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
FORMULA HELP
Yes you're quite right - I would be better at this game if I could read. <g
Just for fun an alternative could be:
=INT(A1)*12^(MOD(A1,1)0)+MOD(A1,1)*100
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"Ron Coderre" wrote in message
...
So you wouldn't want 10 converted to 12.
But you would want 10.4 converted to 124.
...That should have been
So you wouldn't want 10 converted to 120.
But you would want 10.4 converted to 124.
(is it Friday, yet?)
***********
Regards,
Ron
XL2002, WinXP
"Ron Coderre" wrote:
Wouldn't just =INT(A1)*12+MOD(A1,1)*100
I don't think so. According the the post, values without decimal places
are
already stated in inches:
the whole numbers are in inches and the fractions are in feet and
inches like 5feet and ten inches<<
So you wouldn't want 10 converted to 12.
But you would want 10.4 converted to 124.
***********
Regards,
Ron
XL2002, WinXP
"Sandy Mann" wrote:
"Ron Coderre" wrote in message
...
B1: =IF(INT(A1)=A1,A1,INT(A1)*12+MOD(A1,1)*100)
Wouldn't just =INT(A1)*12+MOD(A1,1)*100
work just as well?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"Ron Coderre" wrote in message
...
Try something like this:
For a value in A1
B1: =IF(INT(A1)=A1,A1,INT(A1)*12+MOD(A1,1)*100)
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"steve" wrote:
I have a column of cells with numbers like 5.10, 4.10, and whole
integers
like 60,65,70,etc. the whole numbers are in inches and the fractions
are
in
feet and inches like 5feet and ten inches. If I want all the numbers
to
appear in inches format in the next column ,what formula do I
apply.That
is
the values inches should remain as they are and the values in feet
should
be
converted into inches and displayed. The feet measurements are below
9
feet
in value.
any help in this regard will be appreciated very much.
thank you guys and have a nice day
steve
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann