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 |
All times are GMT +1. The time now is 04:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com