Worksheet Functions - Page 107

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
hOW TO USE eXCEL FUNCTION by SHIV JHA =IF(AND(M26=7501,N26="A"),M26G12,IF(AND(M26=7500,N26="B"),M26F12),IF(AND(M26=7500,N26="C"),M26*E12),0) SO THAT I AM ABLE TO UNDERSTAND IF SALARY OF...	February 21st, 2010 04:15 PM by Teethless mama	2	435
Excel 2007 Error message when trying to record Macro by Beth I recorded a macro. I decided that I did not want the macro to perform the final function that I had recorded. I deleted the last couple of lines of code...	May 16th, 2010 08:32 AM by Manju Manjoo	1	435
Hide used names in drop downbox. by Robb27 I found something I would like for my workbook. I found it on MVP Debra Dalgleish's page http://www.contextures.com/xlDataVal03.html. The original code is from... ( 1 2)	April 24th, 2006 12:24 PM by Robb27	13	435
Why do some Excel cells refer to e-mail? by Fred in Keswick Why do some Excel cells display fonts of a different colors. Specificaly, when I use a sum function, the result appears sometimes in in blue, somtimes in...	February 28th, 2006 10:09 PM by Elkar	1	435
totalizer formula by KARIM I need a totalizer formula? example : A number is put daily in A1, then auto transfered to A2 Next day a new number entred in A1 will be accumulated in A2.(...	December 23rd, 2005 07:58 PM by Gord Dibben	6	435
How do I view the actual numeric value of a formula in Excel 2002. by Excel Function Help In MS Excel 2002 I am unable to see the numeic formula in the worksheet. (i.e. if you add "2" to cell ref A1 and "2" to cell ref A2 and sum the figures you...	January 13th, 2005 10:07 PM by Excel Function Help	0	435
validation list by trey another question..my validation list originally only had 4 items... how do i add items to it...ive added additional items and when i highlight and pull the... ( 1 2)	August 15th, 2004 05:32 AM by Ragdyer	13	434
# of Functions per cell by SUB-ZERO Hi Is there any way to change the number of functions allowed in each cell? I have a spreadsheet and I need it to handle more functions than 7. 10-15...	January 23rd, 2005 10:35 PM by Harlan Grove	3	434
roundoff when converting text to numbers by Jack Can anyone help? When I am converting text to numbers in excel, occasionally some numbers will roundoff, especially if I am converting a number of cells at...	January 30th, 2005 01:51 AM by JulieD	3	434
Copy cell - fill all blank - multiple range by Copy Dave In excel 2002, when i select a cell with blank cells beneath and rest the mouse pointer in the bottom left corner so it changes to a + sign by double clicking...	July 17th, 2004 09:24 PM by Nick Hodge	1	434
How to calculate a response time of 1 to 5 days by Peggy I am currently using the formula provided in Excel help which allows me to calculate the number of working days (NETWORKDAYS) between two dates (Date Received...	May 21st, 2004 03:00 PM by Andy B	1	434
password to open workbook by Margaret How to set up that it is a password is required to open a workbook	October 7th, 2003 04:37 PM by Margaret	4	434
Menu Options "grayed out" but still functional through macros by For some reason, some of my menu options, like Delete Sheet are now grayed out. I can't right-click on a sheet tab for the menu either. However, I can write...	October 30th, 2003 05:10 PM by Ken Wright	1	434
auto filter macro by I want to use auto filter or some other device to hide those rows whose first column has a zero in it. I would like to come up with a macro that automatically...	November 23rd, 2003 09:16 PM by Don Guillett	4	434
Add Calculation Field to Pivot Table by Gray Hi, I would like to perform a calculation by using the following sample data, Month B/S Quantity Jan 1 500 Jan 2 300 Feb ...	January 6th, 2004 05:40 PM by Gray	2	434
number display error with auto calculation by John Hi, Recently I have got a weired problem with Excle worksheet. When I type a number, for instance, typing "8", the cell on worksheet automatic display as...	March 1st, 2004 09:20 PM by John	2	434
Copying Cells without changing data by That's Confidential I currently have a number of cells which contain some functions, referring to specific cells. As these fall onto a new page, I want to copy these cells and...	March 26th, 2004 08:34 PM by Chris R. Lee	4	434
summing number of date entries in current week by Kevind Hi, I've scanned all forums but cannot yet find a solution. Hoping someone in this forum would be kind enough to help out a novice! I have a worksheet which... ( 1 2)	May 5th, 2004 05:04 PM by Frank Kabel	12	434
Formatting data from "Columns and Rows" to just "Rows" by Jonathan Lord G'day, I am currently pulling my hair out attempting to summarise a set of data which is formatted as rows and columns into a format whereby it is just...	September 23rd, 2003 06:06 AM by Mark E. Philpot	1	434
sorting numbers as 1.1,1.9, 1.10 - instead of 1.1,1.10, 1.9 by eusgfo How can I format the cells, or write a function to sort numbers as follows: 1.1 1.2 .... 1.9 1.10 1.11 1.12	October 2nd, 2003 03:08 AM by eusgfo	8	433

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed