Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- excel problem
- I need to find the form to get the real timefor example01/08/2000 to 01/08/2007so the diferences is 7 yearsbut I don´t know how to do it just I wante the diferences....the result = 7 yearJust subtract and divide by 365.25If you place those two dates into cells (say, A1 and...
- Tags: edaen.bedolla.temp@..., B1-A1
- Discussion threads 2007-08-01
Additional Resources
- Excel formula
- Please help Value in Cell A1 is copied into cell B1 and new value is entered in A1B1 should now show old value of A1 plus new value of A1in other words B1=B1+A1How do I do this in Excel. Tried to use if statement, cant figure it outThanksYou will need...
- Tags: ichu50, Microsoft Excel, software
- Q&A 2005-08-20
- Two Broadband connections and One SBS 2003 server
- Hello, I have two broadband connections(one with 256kbps and other with 512kbps )with me and the server has two network adapters.[Two broadband connection because if one A1 goes downor is dead Internet operates on other B1.] Now, can I merge these (A1 and B1) in Two N/W adapters on my...
- Tags: acmahajan@..., broadband, hardware, it management, Microsoft Windows Small Business Server, Microsoft Windows Small Business Server 2003, network management, networking, server, windows
- Discussion threads 2007-01-08
- MICROSOFT EXCEL 2003
- Can anyone help. IF THE LETTER "A" IS ENTERED INTO A CELL BETWEEN (A1:A40) THEN THE NUMBER Fig"1" IS PLACE IN CELLS (B1:B40) If another "A" IS ENTERED BETWEEN (A1:A40)THEN Fig "2" IS PLACE IN CELLS (B1:B40)AND SO ON NUMBERING CELLS IN SEQUENTIAL ORDER 3,4,5. SO IF THERE ARE 5...
- Tags: A1:A40, arrays, B1:B40, buzby@..., excel, feedback, formulas, Microsoft Corp., Microsoft Excel, off-topic, programming, windows
- Discussion threads 2007-01-19
- Anatomy of an Excel formula: Using functions to perform calculations
- CorrectionsThe textIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and B1, inclusive of A1 and B1". should readIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and D1, inclusive...
- Tags: hardware, lschell, Microsoft Excel,
- Discussion threads 2005-08-23
- Take advantage of Excel's DATE function
- better solutiontype date in a1type 'day-of week'in b1type =text(a1;'dddd') in b2enter date in a1 and you will get the day in b2!Help with perpetual date please!I feel stupid. I thought I followed the formula but it isn't working for me. I get an error telling me the formula...
- Tags: ecx@..., Microsoft Excel
- Discussion threads 2004-11-01
- Excel argument/formula question
- Let's say I have the POTENTIAL to have data in cellS A1, B1, C1 and D1. In cell E1 I want to add all four cells together. That's easy. Now in cell F1 I want to say take the total from E1 and divide it by the...
- Tags: Rosstamon, Microsoft Excel, A1:D1, cell
- Discussion threads 2007-07-13
- two wireless networks
- We have two wireless networks let us call it as A1 and B1 now when i am connected on Network A1 i am able to browse the netwwwand are able to do regular work with ease.when i am connected on network B1 i am not able to browse the netwww,and...
- Tags: acmahajan@..., it management, network, Proxy Server, wireless, wireless network
- Q&A 2006-09-28
- microsoft ECXEL help
- Please helpcell A1 to A5 has a text value and cell B1 to B5 has a number value, if cell B1 to B5 present a negative value how can i automatically transfer or populate that negative value to C column and also transfer the text that represent that negative value...
- Tags: Microsoft Corp., russellte2002@..., cell
- Discussion threads 2007-05-17
- IS THERE A FORMULA TO REPEAT WHAT EVER IS IN A CELL?
- I have to repeat the same information in a different cell. But instead of typing it twice, can I create a formula in the 2nd cell to repeat whatever is in the 1st. cell? Sometimes it will be a number and sometimes it will be text typed into the...
- Tags: cell, suzanne_juszcyk@...
- Discussion threads 2007-02-26
- Bad motherboard or bad memory?
- So a fatal error in Xp left me in this situation.Quick run down is, i have two sticks of 512 3200 DDR memory, and a A8N32-sli Deluxe mobo.Stick1 works in all slots (a1 a2 b1 b2)Stick2 works in a1 a2 & b2 onlyWhen ever stick 2 is placed into the...
- Tags: TV & Home Theater, Now-What, cebaxx@..., A1-A2, memory
- Discussion threads 2007-10-26
- Autometic express of numeric value in text in MS exel.
- Suppose in A1 cell a vale inserted 100 and in B1 another value 200 is inserted. Now If C1 cell represent A1+B1=C1 i,e, C1=300 then how this 300 value can autometically typed in text in another Cell D1 i,e, in D1 "Rupees Three Hundred Only" can autometically generate. Remember every...
- Tags: rajusahantc@..., Microsoft Corp.
- Discussion threads 2007-04-13
- Excel Formula
- Bear with me as I try to explain my problem. I have a table that has in cell A1 'Apple' and and B1 '15'. Then using cell C1:D3 as a sort of reference database or lookup table fill in C1 'Apple', C2 'Orange', C3 'Lemon' and in D1...
- Tags: Microsoft Excel, alan@..., Apple Computer Inc.
- Discussion threads 2007-05-17
- two wireless networks
- We have two wireless networks let us call it as A1 and B1 now when i am connected on Network A1 i am able to browse the netwwwand are able to do regular work with ease.when i am connected on network B1 i am not able to browse the netwww,and...
- Tags: acmahajan@..., it management, network, wireless, wireless network
- Q&A 2006-09-26
- Use Excel to calculate the hours worked for any shift
- Calculating hoursThis was great & perfect timing since I'm trying to update the timesheets here. Question for you, I want to build in an option to deduct time for lunch, while still calculating everything properly. I also want the total column to work correctly regardless if they took...
- Tags: parenthesis, cell, decimal
- Discussion threads 2005-06-29
- Two Wireless Networks
- If we put both the wireless routers on the same switch so that the wired desktop and wireless laptops that are connected should be able to surf the internet,then it does not work , or it may have a conflict........soWith two wireless broadband connection (A1 and B1) when i connect...
- Tags: acmahajan@..., broadband, desktop, it management, network, router, swITch, wireless, wireless network, wireless router
- Q&A 2006-09-29
- Excel
- Hello!Can you tell me more please about Row differences and Column differences in Edit, Go To Special dialog box? That answer still not enough clear and it is the same answer in «How to use the Advanced Excel Select».Thank you!Mona R.If you have following data:1 2 32 ...
- Tags: cell, zimonar@..., windows, Microsoft Excel
- Q&A 2006-02-05
- Excel nexted functions
- I'm trying to count student attendance if they are Special Education students, ie =if(f15="P"+ae15="1"),1,0 (if one cell is "P" AND another cell is "1" then return "1")This returns "invalid" or "value" and function doesn't work. When I get the function to work, it returns an incorrect value. How...
- Tags: A1=P, B1=1, blginger@..., C, cell, COUNTIF, Microsoft Excel, software, Special student
- Q&A 2005-12-24
- Help with the IF Function in Excel
- Hi, I am preparing a Tax Calculator using Excel but can't get the formula right. Here's an example:Gross annual income:Below 1000 should be tax free1000-2000 should pay 2202000-3000 should pay 330........above 10,000 should pay 1100 etc, etcI tried using the IF Function but still received errors. Urgent help is welcomed.Try...
- Tags: mamahtm@..., software, Microsoft Excel
- Q&A 2006-08-21
- ORACLE FORMS-pop list index retrieval
- Hi,I have the following problem with a poplist. a. Retrieve all the values and the list index(eg: 1,2,3) from the list item and store them in a pl/sql table. b. When a value is chosen from the list,I need to get the list index from the list for that chosen...
- Tags: B2, list index, madan_bharatwaj@..., Oracle Corp., software, Value at Risk
- Discussion threads 2005-03-13
- << Previous
- page 1 of 1
- Next >>
