Worksheet Functions - Page 103

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.

		Home » OfficeFrustration forum » Microsoft Excel
Worksheet Functions

Home

Page 103 of 4390

103

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Adding ISERROR to formula by Pierre I have this formula in a cell, and correctly returns #N/A where it does not find the data the formula looks for. Have tried ISERROR, ISNA, and ISERR to return...	October 8th, 2007 07:08 PM by Pierre	3	68
Adding # of days to a date by bastien86 I wish to add 125 days to todays current date format in a cell, to display in date format, the date 125 days from now. Can anybody assist me with this?	July 6th, 2006 02:30 PM by Sloth	2	88
Adding "0" as leading digits into cells in Excel by Tippetue How can I add "0's" as additional first digits for numbers in a row containing 4000 random numbers, i.e. change 1346 to become 01346 and 2345 to become...	October 19th, 2006 12:14 AM by Gord Dibben	2	74
adding "Data Analysis" to my Excel by Mirna S I cannot see the "Data Analysis" option under the Tool Menu in Excel. I would like to know what i am missing. what do i need to install to have this option...	August 29th, 2006 05:05 PM by Gord Dibben	2	80
Adding "fixed" data to variable length data by [email protected] Hi, I'm trying to merge together some variable data to some fixed data within Excel but am struggling to come up with an elegant solution to it. I have two...	February 16th, 2006 08:59 PM by Roger Govier	3	135
Adding "OR" to a Sumproduct Formula by carl I use this formula: =SUMPRODUCT(--(D3:D5="Order");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5)) I would like to add the condition: If D3:D5="OrderO" and...	March 21st, 2006 06:43 PM by carl	0	65
Adding (creating) worksheet by Martin Racette Hi, I have create a .XLS file that control some data on a daily basis, what I would like to do now is to create a new worksheet with everything that is...	February 3rd, 2004 03:17 AM by Martin Racette	5	134
adding + and - numbers by Robb27 Hi All: In row A1 through K1 I have either a positive 1, negative 1 or a 0. In cell L1 I want to display the total. The value in A1 through K1 is determined...	July 28th, 2006 09:36 AM by Robb27	4	64
Adding +1 to a text by Myriam I have a column where a user will input Item 1, Item 2, etc. etc. within a range. These inputs are not necessarily contiguous but they will be ascending: A1 ...	October 27th, 2006 07:30 PM by Myriam	0	92
Adding .45 months to a date by Trev I have a project estimation worksheet where I am calculating the number of months remaining, then adding the current date + Months using...	April 25th, 2007 05:31 PM by Ron Rosenfeld	4	47
Adding 1 year and keeping time as well by Hugh G. Johnson I have a column of date and time stamps I want to add excatly 1 year to. The cell I want to add a year to is has this: 6/1/2007 6:35 If I use the forumula...	August 20th, 2008 06:08 PM by T. Valko	5	117
Adding 2 cells together and paste into 1 cell by Steved Hello from Steved In a Worksheet called 1st Week in Col "A" I have "City" and "Panmure", and in Col "B" to Col "H" I have Data. I would like the formula to...	June 29th, 2006 08:18 PM by Steved	4	82
Adding 2 columns together on 1 worksheet with sum on other. by CE Hi, I am working with a workbook that has 3 sheets. I need to add 2 columns together and have the result appear on sheet 1. I've tried =sum('08 compaired...	June 26th, 2009 08:11 PM by Mike H	3	96
Adding 2 for every multiple of 5 by MC0311bravo I'm trying to find a formula that will add 2 for each multiple of 5 for a given cell. Let's say the value of cell A1 is 15. I'm looking for a formula that...	June 6th, 2009 05:06 AM by Teethless mama	4	115
Adding 2 Values When 3 Conditions are Met, Including an "OR" by ANNEM I need to add up dollar amounts in Column D when Columns A and B meet certain critieria and Column C meets either of two conditions. The following should...	August 2nd, 2006 02:45 PM by Excelenator	8	86
Adding 2weeks and rounding up to EOM by Micki I need to add 2 weeks to a date and round it up to the last day of the month. G11: 6/15/2009 Add 2 weeks, but round to 6/30/2009 If I add 14 days to...	June 23rd, 2009 02:13 PM by Micki	3	122
Adding 3 columns of criteria simultaneously by Michael Joseph Cosgriff I have used a RANDOM NUMBERS web page to make a collection of 6 columns from A1 to F50. Now I want to scan them to see if I have repeated any rows. Can...	January 2nd, 2009 03:00 AM by OssieMac	3	113
Adding 3 variable formula to a cell by kssflmail I'm looking for a 3 variable formula for a single cell using figures from 8 cells in a column for Exel 2003. Basically, totalling variable fees for 8 different...	February 20th, 2006 05:11 PM by Peo Sjoblom	3	108
Adding 6 Months to a Date by Excel User Greetings! I have a column with dates. I need to add 6 months to those dates and place the new dates in a new column. How do I do that? Many thanks.	January 25th, 2007 12:16 AM by Ron Rosenfeld	8	73
Adding a % value to a column of numbers by Morefeus Direct hello anyone how can help, i'm new to exel ,now in exel i have a column of different number like 512.00,654.00,68.56, and so on down this colunm and i want...	September 16th, 2006 09:41 PM by Gord Dibben	9	65

Page 103 of 4390

103

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 02:02 PM.