Posted to microsoft.public.excel.misc
|
|
Formula help Mod and square
Hi David,
Yep! just so
Many thanks
--
Mifty
"David Biddulph" wrote:
My guess is that F13 isn't actually a date in Excel terms, but a number like
25122008 being used to represent a date.
--
David Biddulph
"Bernard Liengme" wrote in message
...
Let's look at the first
Suppose F13 hole 12345678
MOD(F13,10^6) says divide F13 by 1 million and return the remainder: you
get 345678
MOD(F13,10^4) says divide F13 by 10,000 and return the remainder; you get
5678
The we subtract to get 340000; then divide by 10,000 to get 34
In the second one we find MOD(F13,10^4) again = 5678
Multiply by 100: 567800
Then we add this to the first answer: 567834
Not sure why you would want this but that is what they do
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Mifty" wrote in message
...
Hi everyone,
Is there any chance that some kind soul could tell me what these 2
formulae
are doing please?
F13 is a date
=(MOD(F13,10^6)-MOD(F13,10^4))/10000
=(MOD(F13,10^6)-MOD(F13,10^4))/10000+MOD(F13,10^4)*100
Thank you very much
--
Mifty
|