b2:e2

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Excel Formula Question

Hi --If I want to sum a row of numbers ONLY IF there are NO blank cells in the row (and if there are any blank cells then the cell where the sum would appear would instead return a message like "BLANK CELL FOUND", then how do I do this?...

Tags: B2:E2, BLANK CELL FOUND, cell, johnshenyang@..., Microsoft Excel, software

Q&A 2005-10-14

Excel Question

Hi --If I want to sum a row of numbers ONLY IF there are NO blank cells in the row (and if there are any blank cells then the cell where the sum would appear would instead return a message like "BLANK CELL FOUND", then how do I do this?...

Tags: B2:E2, BLANK CELL FOUND, cell, Excel Question, johnshenyang@..., Microsoft Excel

Q&A 2005-10-14

Additional Resources

Create a combo box for users' data in an Excel chart

Error in formulas??After copying formulas from B2 to C2:E2 I had to change the reference $A$2 to $B$2 to make it work.B2 reference worked OK for meMaybe the Format Control for the combo box wasn't entered correctly.The cell link should be A2.Then the # of the...

Tags: combo box, combo box for users' data in an excel chart, B2, GSanderL@..., hardware, Microsoft Excel

Discussion threads 2006-05-05

Create a combo box for users' data in an Excel chart

Combo boxes in Excel are handy because they allow individual users access to various ways to view data without changing the integrity of the information itself. Mary Ann Richardson explains how to set up combo boxes that let users decide which data to chart. When it comes to data...

Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, combo box, sales, Microsoft Office Suite Excel Tips Newsletter, Box, Office Suites, Software

Technical articles 2006-05-02

B2 Spice A/D Lite (EXE)

The predecessor to our latest program, B2 Spice v5 a fully featured mixed mode simulator that builds upon B2 Spice A/D 2000 and adds its own features to make it the simulator of choice for power Spice users. New features include a parts chooser window, workspace editor, importing, and exporting...

Tags: Feature, Construction

Software downloads 2005-04-04

EasySMS Outlook (zip)

EasySMS Outlook intended for mobile based SMS text service to mobile client mobile phone users. EasySMS Outlook is common remote client for NetShell e2.0/StarLink e2.0 it uses to upload message to remote server NetShell/StarLink. Features: group messaging, user friendly configuration, fetch reports from server, and fetch message from Netshell e2.0.

Tags: Microsoft Outlook, Mobile, EasySMS Outlook, Advertising & Promotion, Marketing

Software downloads 2007-04-12

Help on an Excel formula

I need some help on an Excel formula..I need to calculate a formula to count the exact number of days between two dates.For Example:Cell A1 contains 01/01/2007Cell A2 contains 31/01/2007Cell A3 needs to contain the answer (31)All the formula's i can think of return the answer (30).I would very much...

Tags: Microsoft Excel, benpatel@..., DATEDIF, A2,B2, DATEDIF function

Discussion threads 2007-10-14

Cracking Open the Tungsten E2 Palm PDA

Drew McBee has a Tungsten E2 Palm PDA that needed a new battery. Lucky for us, he decided that this would be an opportunity for a Cracking Open Gallery by Drew McBee

Tags: TechRepublic Inc., palmOne Tungsten, PDAs, Handhelds, Hardware, Drew McBee, product photos, pda, palm, Tungsten E2, cracking open

Image galleries 2008-11-07

Bredbandsbolaget Rolls Out Next-Generation Fibre-to-the-Home Residential Broadband Services Over Cisco IP NGN With New Carrier Ethernet Access Solution

Bredbandsbolaget (B2) offers high-speed broadband for Internet access, telephony, digital-tv and add-on broadband services. B2 has seen an increase in residential subscribers as the company extended its network reach to over two million Swedish households, or two-thirds of the population, through the build out of its network based on the...

Tags: Microsoft Access, Network, Cisco Systems Inc., Carrier, B2, Ethernet, Networking

Case studies

Cut down on worksheet typing with Excel formulas

b2:e2 same valuehow to work with to get other value not firstHere's an easier wayOn Sheet 1, create your header row or column labels. For an example, we'll use the same B2:E2 range as the orginal tip. On sheet 2, in B2 enter =Sheet1!B2. Then use the copy-handle and drag...

Tags: error message with komma, hardware, martin.obermeier@..., Microsoft Excel

Discussion threads 2005-12-07

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

B2 Spice A_D (EXE)

The version 5.1 of the popular and powerful mixed mode electronics circuit simulator builds upon B2 Spice A_D v4 powerful capabilities to reach new standards in ease-of-use, power, and capabilities. New features include: virtual instruments, live circuit mode with interactive parameters, redesigned user interface, animated schematics, circuit wizards to automatically...

Tags: Electronics, Circuit

Software downloads 2005-05-20

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

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

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

calculate interest between dates

i like to know that how to calculat amount of interest between two dates in a exel worksheet when rate of interest varies with financial year i:efrom 1/4/2000 to 31/3/2001 rate is 10%from 1/4/2001 to 31/3/2002 rate is 10%from 1/4/2002 to 31/3/2003 rate is 10%from 1/4/2003 to 31/3/2004 rate is...

Tags: arvindcfridhanbad@...

Q&A 2005-06-24

Time Stamp Capturing

I want to capture time stamp for each cell entry in a particular column and i have around 150 rows in that column and i want when ever a value is entered in any row in that column i get the time of entry capture on any other cell and...

Tags: amit.suneja@...

Q&A 2006-05-15

Excel Autonumber

I need to allocate an incremental number to a cell in the Count column based on one of three options typed into the Item cell adjacent as follows:Item CountA 1B 1C...

Tags: C/C++, Programming languages, colin.radcliffe@..., Microsoft Excel, Countif, C

Discussion threads 2007-10-16

Excel Programming

SE |Amount | CJA | FSV--------------------------FSV | 1 | | 1--------------------------CJA | 2 | 2 |--------------------------FSV | 3 | | 3--------------------------Gurus,Based on the...

Tags: CJA Column, FSV, Microsoft Excel, programming, shaundyc, software

Q&A 2004-12-06

Use Excel to calculate the hours worked for any shift

With Excel, you can create a worksheet that figures the hours worked for any shift. Here's how. To calculate in Excel how many hours someone has worked, you can often subtract the start time from the end time to get the difference. But...

Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Category List, Format Cells, Microsoft Office Suite Excel Tips Newsletter, Box, TechRepublic Inc., Office Suites, Software

Technical articles 2005-06-23