Thread: using the MOD funktion in excel 2003

if you look at the column headers you see A, B, C; and i am using a
norwegen version of office 2003 i downladed the file you referd to but
execl will not alow me to install it.

Omar Elroubi



Dave Peterson Wrote:
> =mod() shouldn't cause an error.
>
> My first guess...
>
> If you look at the column headers, do you see A, B, C, ...
> or do you see 1, 2, 3, ...
>
> If you see numbers, try changing this:
> tools|Options|General Tab|uncheck R1C1 reference style
>
> And reenter the formula.
>
> ===
> Or maybe =mod() is called a different name. Do you use an English
> version of
> excel?
>
> If not, maybe this will help:
>
> KeepItCool has a translator utility at:
> http://members.chello.nl/keepitcool/download.html
>
>
>
>
> a2apple wrote:-
>
> start time
> 11:00:00 PM (A3)
> end time
> 3:00:00 AM (B3)
>
> i am trying to use mod to work out the number of hours that a person
> worked using excel
>
> so i used the following formula =mod(B3-A3,1) i keep getting the
> following error #Name?
>
> thanks in advance for any help i can get
>
> --
> a2apple-
>
> --
>
> Dave Peterson


--
a2apple

Try REST(). I found something that gave a "translation".

"a2apple" wrote:

>
> if you look at the column headers you see A, B, C; and i am using a
> norwegen version of office 2003 i downladed the file you referd to but
> execl will not alow me to install it.
>
> Omar Elroubi
>
>
>
> Dave Peterson Wrote:
> > =mod() shouldn't cause an error.
> >
> > My first guess...
> >
> > If you look at the column headers, do you see A, B, C, ...
> > or do you see 1, 2, 3, ...
> >
> > If you see numbers, try changing this:
> > tools|Options|General Tab|uncheck R1C1 reference style
> >
> > And reenter the formula.
> >
> > ===
> > Or maybe =mod() is called a different name. Do you use an English
> > version of
> > excel?
> >
> > If not, maybe this will help:
> >
> > KeepItCool has a translator utility at:
> > http://members.chello.nl/keepitcool/download.html
> >
> >
> >
> >
> > a2apple wrote:-
> >
> > start time
> > 11:00:00 PM (A3)
> > end time
> > 3:00:00 AM (B3)
> >
> > i am trying to use mod to work out the number of hours that a person
> > worked using excel
> >
> > so i used the following formula =mod(B3-A3,1) i keep getting the
> > following error #Name?
> >
> > thanks in advance for any help i can get
> >
> > --
> > a2apple-
> >
> > --
> >
> > Dave Peterson
>
>
> --
> a2apple
>

Just to add to Barb's response...

Excel's VBA is USA centric. You can use that to your advantage.

Select an empty cell in a worksheet (not A3 or B3, though!)
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:

activecell.formula = "=mod(B3-A3,1)"

Then back to excel to see how it was translated.



Barb Reinhardt wrote:
>
> Try REST(). I found something that gave a "translation".
>
> "a2apple" wrote:
>
> >
> > if you look at the column headers you see A, B, C; and i am using a
> > norwegen version of office 2003 i downladed the file you referd to but
> > execl will not alow me to install it.
> >
> > Omar Elroubi
> >
> >
> >
> > Dave Peterson Wrote:
> > > =mod() shouldn't cause an error.
> > >
> > > My first guess...
> > >
> > > If you look at the column headers, do you see A, B, C, ...
> > > or do you see 1, 2, 3, ...
> > >
> > > If you see numbers, try changing this:
> > > tools|Options|General Tab|uncheck R1C1 reference style
> > >
> > > And reenter the formula.
> > >
> > > ===
> > > Or maybe =mod() is called a different name. Do you use an English
> > > version of
> > > excel?
> > >
> > > If not, maybe this will help:
> > >
> > > KeepItCool has a translator utility at:
> > > http://members.chello.nl/keepitcool/download.html
> > >
> > >
> > >
> > >
> > > a2apple wrote:-
> > >
> > > start time
> > > 11:00:00 PM (A3)
> > > end time
> > > 3:00:00 AM (B3)
> > >
> > > i am trying to use mod to work out the number of hours that a person
> > > worked using excel
> > >
> > > so i used the following formula =mod(B3-A3,1) i keep getting the
> > > following error #Name?
> > >
> > > thanks in advance for any help i can get
> > >
> > > --
> > > a2apple-
> > >
> > > --
> > >
> > > Dave Peterson
> >
> >
> > --
> > a2apple
> >

--

Dave Peterson