Question about Microsoft Excel for PC

2 Answers

Excel i'm trying to get a cell to add up a b c and d and ahow zero when a letter is placed in either a or c with b and d blank Date Morning Afternoon Total worked time Credit for absence Debit Type* of absence Authorised by . Daily Total (7+8+9) Credit/Debit Balance . Arrive Depart Arrive Depart 2 3 4 5 6 7 8 9 10 11 12 13 28-Feb-05 07:20 12:30 13:00 15:39 07:49 07:49 24:13:00 01-Mar-05 A/l A/L #VALUE! ###### #VALUE!

Posted by on

  • 1 more comment 
  • voile Nov 12, 2008

    if a word is put in cell A or B cell C reads 0 if figures are put in A & B cell C counts figures (I'm doing it with time)

  • voile Nov 17, 2008

    Thanks for trying but it does not work at all

  • Frank
    Frank May 11, 2010

    what are you try to solve??
    adding colum???
    want to send a sample, so I can figure out what you want?

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 45 Answers

=IF(AND(ISBLANK(b),ISBLANK(d),OR(ISTEXT(a),ISTEXT(c))),0,a+b+c+d)

Posted on Nov 17, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,605 Answers

This is little beyond what I know, however, I can do count characters, but not numbers. do a search on the web, there are lots of method for counting characters, you can reverse the count.
I think you need is a program to do that.
you can find viusal basic, c++ user group on the web, they may be the best bet.

good luck

Posted on Nov 12, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

What is the percentage increase if one cell is blank and the other is 383 in Microsoft Excel 2010?


That is an unsolveable question. You have to have a Non Zero Starting point in order to calculate a percentage of increase. Black is essentially 0. and no % increase of 0 will bring you anything but 0

Sep 08, 2014 | Microsoft Excel 2010

2 Answers

I get an error when I tally cells that have errors because of dividing empty cell by empty cell.


Hi I dont really have much to do with Excel as I essentially build and repair and install, gosh I still type with two fingers!! Now below I have provided a link to Microsoft . Ways to count values in worksheets etc. If the problem persists try to update Office with what ever sercice packs are required and see if this helps. the link is http://office.microsoft.com/en-au/excel-help/ways-to-count-values-in-a-worksheet-HA010287849.aspx and I do hope it helps.
Cheers

Oct 28, 2011 | Microsoft Excel for PC

3 Answers

NEED TO AVERAGE CELLS, WHERE ONE OR MORE CELLS CONTAIN ''0'' OR ''#D


Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

Aug 26, 2009 | Microsoft Office Excel 2007

1 Answer

To be notified 7 days before todays date


You can write a macro for that and needs to run every time after opening of the excel sheet.

Jan 23, 2009 | Microsoft Excel for PC

1 Answer

Need to Add Dates in Excel


Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)
That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

1 Answer

EXCEL


Add an IF statement that encloses the formula you've already written. Assuming the result is in one cell, called CELLREF for purposes of writing this for you:
=If(CELLREF>0,CELLREF,(------INSERT YOUR FORMULA ABOVE------),0)
Thank you for rating FixYa!

Apr 23, 2008 | Microsoft Excel for PC

2 Answers

Time on the phone


This must be done at extension 10 or 11:

Press Feature and dial zero zero

Press the left intercom button twice


To set the time, press the pound (#) key and dial 103. Enter the correct time using a 24-hour clock (if it's afternoon, add 12 to the hour...i.e. 3pm is 1500)


To set the date, press the pound key and dial 101. Enter the correct date using the format MMDDYY (two digit month, two digit day, two digit year).


Press Feature and dial zero zero to save your changes.

Nov 01, 2007 | Avaya Eurostyle 18D Corded Phone

1 Answer

Change time


This must be done at extension 10 or 11:

Press Feature and dial zero zero

Press the left intercom button twice


To set the time, press the pound (#) key and dial 103. Enter the correct time using a 24-hour clock (if it's afternoon, add 12 to the hour...i.e. 3pm is 1500)


To set the date, press the pound key and dial 101. Enter the correct date using the format MMDDYY (two digit month, two digit day, two digit year).


Press Feature and dial zero zero to save your changes.

Oct 30, 2007 | Avaya Eurostyle 18D Corded Phone

2 Answers

Budgets in excel


Dear Madiha35,

 

I would recommend the use of the Table Function in Excel.

 

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

 

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

 

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

 

Step 1:  Enter your data into the worksheet.

 

Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table

             

Step 3:  Verify Table range is correct, Click OK

 

Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.

 

Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above

 

Step 6:  Enter new data in row

 

Step 7:  Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

136 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18346 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...