General
in [Excel]
|
IF ERROR FORMULA =IFERROR(N2,O2),IFERROR(O2,P2),IFERROR(P2,Q2),IFERROR(Q2,R2),"0" I am using this formula in Column I to Check rows N, O, P,Q, and R to copy the dollar amount that is in one of the four fields. There is never an instance where there is a dollar amount in more than one field and if there is no dollar figure in a... 24 May 2010 13:29
Can I use "OR" in two auto-filters/custom filters? Hi! Columns A and B both have dates entered. Col A is a start date and Col B is an end date. I want the user to filter using a combination of the two. For example... I want to show all lines of data that have dates that fall between 1/1/10 and 5/5/10. That could mean that the start date or the end date fall... 24 May 2010 13:29
run external programs I want to make another program run from from excel. Is this possible? ... 24 May 2010 16:50
Sort fails on one column I've been working with a spreadsheet, using different sorts on it. But suddenly one of the columns became a no-op for sorting, whether I sort on that column alone or do a multi-column sort. The only thing I did of interest was to define a pulldown list (for a different column) in a column over at the right, which i... 24 May 2010 13:29
Collecting data I have an evaluation sheet created in Excel 2003. I have a number of questions which have responses eg. poor, fair, good, excellent etc. These will be answered by ticking in an 'ActiveX Check Box'. Beside each question the respondent can add comments, for this I used the 'ActiveX Text Box' with a scroll bar. W... 24 May 2010 11:15
Why does following step not working for excel? I have tried following step for skipping message when file is opened, but message is still pop up, and I get no clue, Does anyone have any suggestions? Thanks in advance for any suggestions Eric Automatic update and no message To suppress the message and to automatically update the links when you open a wo... 24 May 2010 11:15
use VLookup to copy more than 1 cell I have been using VLookup in Excel 2003 for some time but I would like to expand the VLookup results. Instead of just copying one cell to paste as the result of the formula, can I have VLookup copy and paste a series of cells from same row of the found item? Thanks and have a great day!!! :) ... 24 May 2010 16:50
changing the number of rows the mouse scrolls through i know this is a simple question, but for the life of me i can't remember how to change the scroll wheel setting to go from scrolling through 3 rows at a time to one roll at a time. and before you say "go to mouse under control panel"--did that three times already. there is no *obvious* way to change the sett... 24 May 2010 10:08
automatic calculate at specific month Hi, Can anyone help me to make a formula which can automatically calculate a retire fund: a staff join company on April 20, 2010, salary $15,000, I need to calculate his retire fund on the third month, which is June 30. So on June 30, the total retire fund on June 30 that company needs to pay should be: 275... 24 May 2010 07:58 |