Worksheet Functions - Page 106

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
Adding A Not(IsBlank) To IF Statement(help) by getmhawks I want to add something to this formula that makes the statement false if there is nothing in cell C12. How would I add a not(isblank(C12)) statement to this...	June 12th, 2006 10:43 PM by Biff	2	90
Adding a Number and Formula Text and Evaluating by obrien234 I have two separate cells. One is a number, for example cell B1 with a value of 0.109. The other, B2, is in the format "* A1". I'm trying to combine the...	July 1st, 2008 09:02 PM by Gord Dibben	1	69
Adding a number to a letter of the alphabet to get a letter by [email protected] Hi all, I require a function/formula that adds a value to a refernce to a cell that contains a letter of the alphabet so that the vaue returned is another...	May 21st, 2007 04:25 PM by Rick Rothstein \(MVP - VB\)	5	62
Adding a Number value to Time by Corey I have say Column A with Number values (1.0,0.25,0.50,0.75..... etc) Representing Hours In say Column B i have the time (hh:mm) EG. A B	June 26th, 2006 04:50 AM by Max	4	76
adding a percentage by Wendy I know this is going to be an easy solution but right now it is driving me nuts! I have a worksheet that I use to calculate freight charges, in each column I...	June 30th, 2004 03:53 PM by Bernard Liengme	2	83
adding a percentage for COLA to Payroll worksheet by luvkisn I have a worksheet that I have all of our positions and payroll figures. We need to update by adding an annual COLA of 2%. How do I do this without having...	July 13th, 2009 11:33 PM by Rajesh Mehmi	2	83
adding a percentage to a column of numbers by hld I have a price sheet. I want to add a percentage to the price. A column of prices, without doing to each cell. example 5*120%=11	September 5th, 2008 12:40 AM by Gord Dibben	3	66
Adding a percentage to a figure by Newbie I am trying to figure out how to add a percentage to, say column A and have the figure appear in column B. i.e. If column A cell 1 has 37 and I want to type...	September 11th, 2008 07:39 PM by Meebers	2	59
Adding a period to the "=LEFT()" function. by Stilla I am converting a list of names to first initials using the =LEFT() function, but can't figure out how to add a period afterthe first initial? Is there a way...	February 8th, 2006 09:46 PM by Stilla	8	83
Adding a pre-fix to each item in a cell by nasadell I have a column that contains cells that either have: nothing (blank), one word, or multiple words separated by commas. I need to add a pre-fix to each word...	April 15th, 2009 10:51 PM by Glenn[_6_]	1	85
adding a price to an item in a drop-down list by Nat Okay, I have created a data-validation for a list of items, however, i need the list, so that whatever item you pick from the list produces a price into the...	October 27th, 2003 03:12 AM by Tom Ogilvy	1	427
ADDING A PRINT CONTROL BUTTON by Tonya I have a work book that i enter everthing on the first sheet and it puts information in the other sheets in the work book. how can i add a button to the...	September 25th, 2006 09:55 PM by Otto Moehrbach	1	58
Adding a Range by Joey041 I have spent my weekend on this and still canâ€™t figure it out. I have a workbook with two worksheets, one is Data and one is Report One the Data worksheet...	November 21st, 2006 09:23 AM by [email protected]	1	60
Adding A range of cells that have a certain text letter by Dave How do I create the formula that will add a range of cells with a certain text letter? Ex. A1 =NCW A2 =NCFY A3= NCWF A4=NCFP I want A5 to contain the number...	September 7th, 2006 06:13 PM by Nobody	3	56
adding a round function to an existing formula by Deb Paiement The value in some of the fields to look up are decimals. EX: The result in the field is 5.6. The lookup is seeing this as 5 instead of 6. My formula is...	July 10th, 2008 09:28 PM by Deb Paiement[_2_]	2	75
Adding a Row to Multiple Worksheets at Once by Jamie Iâ€™m working in Excel 2003. Iâ€™m working on a project that will track employeeâ€™s errors (dollar, procedure, or no errors). I have 13 worksheets. The...	June 21st, 2007 02:20 AM by Vasant Nanavati	3	70
Adding a row to reconcile to a new worksheet by Galen I have a variety of projects that are all tracked off of a common template. Each project is an individual worksheet with a front sheet used as a project...	October 31st, 2009 07:27 PM by Otto Moehrbach[_2_]	1	122
Adding a row to worksheet does not update cell references in another. by blausen Question: Is there a way to make Excel automatically update these links to the other sheets of the same workbook? The links will update IF I insert a row or a...	February 25th, 2006 09:14 PM by RagDyeR	5	270
Adding a scroll bar by billieburke I think I've added a scroll bar to a cell, but don't know how to get it to function.	March 25th, 2009 03:31 PM by billieburke	0	59
adding a search box to a spreadsheet by Adding a search box to a spreadsheet I have a workbook with 92 tabs containing data and text. i would like to add a search box to my index tab. This search box would allow a user to type in what...	November 30th, 2008 11:19 PM by Gord Dibben	1	51

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