1 Resources for

c6

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Excel formula: I am trying to write an "if blank" formula in ExcelI have the following formula working - =if(blank(D6),0,E5+D6)this checks D6 and if blank, enters 0. If not blank, E5 is added to D6.I need to check that D6 and C6 are both blank.Any suggestions.Thanks=if(blank(D6) & blank (C6),0,E5 + D6)I...; Tags: 0,E5 D6, C6, D6, hduff@..., Microsoft Excel, software; Q&A 2005-10-05

Additional Resources

If Function Help Please: I am trying to make an IF function on my AS spreadsheet project basically I need it to be along the lines of=IF(C3=1 hour and C6=adult,£18,"")Not sure how to do the and part and how I can use the words instead of using numbers as I have to use text...; Tags: jessrulesdaworld@...; Discussion threads 2007-02-28
Surround Sound: I have an Asus P5B-MX/WiFi-AP mobo running Fedora 7 (2.6.22.7-85.fc7) with the Intel Corporation 82801G (ICH7 Family) High Definition Audio Controller (rev 01)I have installed 1.) alsa-kmdl2.) alsa-lib3.) alsa-driver4.) alsa-utils5.) alsa-toolsspeaker-test -c6 -tw only plays through the left and right channels.speaker-test -Dplug:surround51 -c6 -s1 -f75 replies with -ALSA lib pcm.c:2144snd_pcm_open_noupdate)...; Tags: StormRage; Discussion threads 2007-10-12
Excel Question: I am hoping to come up with a formula, which I have been trying to figure out for some time now.I have Column A which contains a list of thyroid values. I want to come up with a way of having 3 cells in Column B SUM the patients from...; Tags: Microsoft Excel, cronk005@..., patient; Discussion threads 2007-06-08
Do nothing in an excel formula: I want to write an "if" statement that if the value is false I want excel to do nothing, (not a 0 or anything). I want it to leave the data in the cell that is already there. Ex:Formula in cell a6=if(a2="April",b5+b6+b7,do nothing)That way if I change the month to...; Tags: rovest@...; Discussion threads 2007-04-13

Excel Formula Question - Autofill: Hi there,I'm a grad student doing a project using weather data and i need urgent help on calculations with my data in excel please.I have wind speed data for every 10minutes in a column but i need to work out the average for every half an hour. I started off...; Tags: gaunt.sarah@..., Microsoft Excel; Discussion threads 2007-03-25
Use Excel's Solver tool to schedule your employees: Solve a problem with Excel's Solver. This tool can help you help you optimize your employees by determining the right number of techs you need at any particular time. You don't need to guess when it comes to determining how many employees you will need to cover a shift...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Use Excel, tool, Solver, Click OK, Microsoft Office Suite Excel Tips Newsletter, Box, Cell, Productivity, Office Suites, Software; Technical articles 2007-05-22
Excel - Sum and Average every other row: I have an Excel spreadsheet that has data in every other row starting in cell C2 and ending in cell C62. I am trying to get my spreadsheet to calculate the average of all of the data in these cells. I know how to do an average formula,...; Tags: Microsoft Office, Rosstamon, cell, Microsoft Excel; Discussion threads 2007-07-31
Use stacked Excel charts to compare data over time: When you need to present two or more Excel charts of similar items, rather than present them separately, stack them together so that they are easier to compare. For example, you're tracking customer service calls for two of your products in a separate spreadsheet. Follow these steps to create a...; Tags: Chart, Tab, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson; Blog posts 2007-09-25
Generating random letters in vb 6.0: Hi allSorry should have explained this in more detail, here's what I want to do.I have one form with 5 text boxes on it and need to generate random letters between A-F and random Numbers between 0-9 For Example: Text box 1 A0, Text 2 B7 Text 3 F9 Text...; Tags: random letter, text box, markjenkins74@..., programming, Rnd, Text1; Q&A 2006-05-26
Microsoft Excel 2003: I have a workbook with several worksheets, within the workbook I have a master worksheet that has a compilation of all the other worksheets. What I need to happen is I want to add the total columns in the other worksheet and display the totals on the master worksheet; the...; Tags: worksheet, tru.notoma@..., IBCT NG, windows, windows xp, security, software, career, it management, hardware, networking, excel, e-mail, microsoft office 2003, workbook, Microsoft Corp., Microsoft Excel, cell; Discussion threads 2007-02-22
Make Excel spreadsheets easier to read with 3-D effects: Microsoft Excel spreadsheets are a fantastic way to organize data; however, sometimes your spreadsheets may get a bit cluttered and become hard to read. Find out how you can use 3-D effects in Excel to make your spreadsheets much easier to read. Microsoft Excel spreadsheets are not only supposed...; Tags: 3D, Microsoft Excel, Microsoft Office, Mary Ann Richardson, PRODUCTIVITY, Excel spreadsheet, border button, Format Painter button, Format Painter, spreadsheet, cell, Microsoft Office Suite Excel Tips Newsletter, Button, C5, D5, Office Suites, Software; Technical articles 2005-08-10
Troubleshoot TCP/IP WIN XP: Please help me to trobleshoot IP settings I tried the network diagnostic test from Win XP Help. Following is the error log:As you can see the diagnostic test has failed in DNS server search order & IP AddressPlease helpNetwork Adapters [00000000] Realtek RTL8139/810x Family Fast Ethernet NIC FAILED Caption...; Tags: Domain names, NETWORKING, Network technology, Microsoft Windows XP, sumeetsardesai@..., Request Timed, REALTEK RTL8139/810x, Realtek, IP; Discussion threads 2007-08-12
Use quiz scores to help Goal Seek training hit home: Learning Excel's Goal Seek feature is difficult for students perplexed by accounting terms and methods. Cut through the confusion by teaching demo problems almost all students understand. Show them how Goal Seek can manipulate their quiz scores.Most courses introduce Excel’s business analysis tools with a demonstration of Goal Seek. Because...; Tags: Microsoft Excel, Operational accounting, Financial services, Financial accounting, training, Mary Ann Richardson, Goal Seek; Technical articles 2000-08-24
Upgrading to a Gigabit Network: I have a question related to upgrading a fast ethernet network to a gigabit network. We have upgraded all desktop NICs to support gigabit EN, we have also purchased all gigabit switches for our servers...but, will this all matter if we keep our Cisco 1720 router in place? ...; Tags: Routers & switches, Network technology, NETWORKING, jeffrey.ho@..., router, network; Discussion threads 2007-06-25
FTP time out error between two Windows 2000 PCs(2 NICs and 2 IP addresses): Problem:Unable to FTPfrom bash window from one Windows 2000 Cygwin PC (with two NIC cards/two IP addresses) to another Windows 2000 Cygwin PC (with two NIC cards/two IP addresses). The FTP command returns a time out error.etc> ftp 10.1.2.7ftp: connect: Connection timed outftp>fts> ftp 10.1.2.6ftp: connect: Connection timed outftp>...; Tags: acampagn@..., FTP, 2 ip addresses, feedback, windows, software, hardware, networking, programming, nic, Microsoft Windows, Microsoft Windows 2000, IP, PC, IP address, password; Discussion threads 2007-02-03
FTP time out error between two Windows 2000 PCs(2 NICs and 2 IP addresses): Problem:Unable to FTPfrom bash window from one Windows 2000 Cygwin PC (with two NIC cards/2 IP addresses) to another Windows 2000 Cygwin PC (with two NIC cards/2 IP addresses). The FTP command returns a time out error.etc> ftp 10.1.2.7ftp: connect: Connection timed outftp>fts> ftp 10.1.2.6ftp: connect: Connection timed outftp>...; Tags: acampagn@..., FTP, windows, software, networking, Microsoft Windows, Microsoft Windows 2000, IP, PC, IP address, password; Discussion threads 2007-02-03
How to teach charting in Excel in 15 minutes: It's best to be thorough when introducing a new subject, but trainers don't have the luxury of unlimited time. These Excel tips on how to teach charting in 15 minutes will help you cover a lot of ground in a short period of time.Teaching an onsite course in beginning Excel...; Tags: PRODUCTIVITY, Mary Ann Richardson, tool, Microsoft Excel; Technical articles 2000-10-03
Balancing personal budgets can help students learn Excel's Solver: Textbook examples often use business concepts to illustrate a tool or function. But sometimes, students can learn more from everyday examples, such as creating a household budget. Learn how to use a personal budget to teach the Solver feature in Excel.When it comes to solving problems where any number of...; Tags: Mary Ann Richardson, Microsoft Excel, Solver; Technical articles 2000-09-11

<< Previous
page 1 of 1
Next >>

Harness the Full Power of Internet Explorer: This pre-packaged presentation contains everything you need to instruct end users about how to the most out of the Internet and Internet Explorer--eve ...; Buy Now

IT Hardware and Software Purchasing Policy: Your IT Budget is tight. You want to get the most bang for your IT buck. That's where the IT Hardware and Software Purchasing Policy can help.
Thi ...; Buy Now

c6

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Additional Resources

Dedicated Hosting