Question about Microsoft Computers & Internet

1 Answer

Excel formula I am wanting to optain a net value by deducting values in two columns. some of the column contain emty cells resulting in a error message #Value. Could you help with this?

Posted by on

Ad

1 Answer

Dalenh,
in Excel this problem dosent come normally if we set cell format to general type.
However, if you want, you can try following :-

=value(Cell1)-value(cell2)

Zulfikar Ali
09899780221

Posted on Nov 04, 2008

Ad

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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Vlookup for duplicate cell values to display both names in separate cells


Check your formulae for a small error. Use F1 to guide you.

Jul 14, 2017 | The Computers & Internet

10 Answers

In Excel adding positive and negative numbers


Yes,


  1. Select the column. (click on top of the column it will select)
  2. Right Click and select Format Cells.
  3. Select Currency in Category then press OK
b6298df.gif Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

1 Answer

How do i subtract two cells and progress down a row by a day so the next day the formula subtracts the current day and previous day?


You have to start the sequence with a slightly different formula because there is no preceding value for Monday.
25525374-qztzwsd5tae24twsq5kxbvm0-3-0.jpg The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.
25525374-qztzwsd5tae24twsq5kxbvm0-3-2.jpg Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

Mar 06, 2015 | Microsoft Excel 2010

1 Answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.


The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

1 Answer

Count how many times a value appears in a column, based on anothe


Go to the cell you want this total in.
Type this formula:
=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))
make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Dec 21, 2008 | Microsoft Excel for PC

1 Answer

How do I say look at cell on left rather than the cell number


vlookup can only locate values within the lookup range and to the right of the lookup column. to address your concern, i'd advise you to create a dummy column within the lookup range (and hide it) and link it to the lookup column. this way, we won't need a (-) column index number.

Oct 31, 2008 | Microsoft Excel for PC

2 Answers

Excel will not displaying the results of a trend array formula


Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

2 Answers

Help


go to page setup and under scaling you can adjust to your required percentage

Jul 22, 2008 | Microsoft Excel for PC

1 Answer

Lookup,s


If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.
To do this, do the following:
1) Move the C Column to be the A Column, shifting all other columns to the right.
2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)
3) Use A1 as your search field.
4) In A2, enter the following formula:
=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:
$A$1 -> the search field (name your looking for).
$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.
3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.
Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

0 Answers

What is Microsoft office applications? Microsoft office is a set of interrelated desktop applications, servers, and services, collectively referred to as an office suite, for Microsoft Word: a word processor included in Microsoft Office and some editions of the now-discontinued Microsoft Works Microsoft Windows and macOS operating systems. Microsoft Excel: a spreadsheet. Microsoft released the first version of Excel for the Mac OS in 1985, and the first Windows version (numbered 2.05 to line up with the Mac) in November 1987. Microsoft PowerPoint: a presentation program used to create slideshows composed of text, graphics, and other objects, which can be displayed on-screen and shown by the presenter or printed out on slides. Microsoft Access: a database management system for Windows that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. Microsoft Access stores data in its own format based on the Access Jet Database Engine. Microsoft Outlook: a personal information manager that replaces Windows starting in Office 97, it includes an e-mail client, calendar, task manager and address book. Microsoft OneNote: a notetaking program that gathers handwritten or typed notes, drawings, and audio commentaries. Notes can be shared with other OneNote users over the Internet or a network. Microsoft Publisher: a desktop publishing app for Windows mostly used for designing brochures, labels, calendars, greeting cards, business cards, newsletters, website, and postcards. Microsoft Project: a project management app for Windows to keep track of events and to create network charts and Gantt charts, not bundled in any Office suite. Microsoft Visio: a diagram and flowcharting app for Windows not bundled in any Office suite

Dec 28, 2017 | Microsoft Computers & Internet

Computers & Internet Logo

Related Topics:

59 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2905 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18411 Answers

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

Answer questions

Manuals & User Guides

Loading...