Worksheet Functions - Page 501

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
Changing Cell References To a Different Worksheet in the Same Cell by DL I have several spreadsheets which contain calculations based on a master sheet called FT_Data. I ran the exact same calculations on another dataset which...	March 30th, 2006 11:18 PM by David McRitchie	3	81
changing cell value makes the formula plain text by spandon I have a working formula: =COUNTIFS(E3:E74,"In Progress",F4:F74,A97)+COUNTIFS(E4:E74,"Not Done",F4:F74,A97) BUT when I change something like E3, to E4, the...	December 22nd, 2009 04:59 PM by Jacob Skaria	1	146
Changing cell values based on another cell by gfreed My question is lets say I want to get the sum of A1 and A2 and send the sum to cell B5. How do I send or change the value of a cell without having my...	February 18th, 2008 10:38 PM by Roger Govier[_3_]	5	117
changing cells depending on another cell. by Skills Hi I have a spreadsheet with 2 columns, one is Items and the other cost. I want a number to be added to the cost cells depending on what the user puts into...	October 3rd, 2004 06:35 AM by Ashish Mathur	3	224
changing cells depending on another cell. by Skills Hi Sorry I did'nt make it clear, I want the user to be able to enter anything in the item column and then the cost to be shown in the...	October 3rd, 2004 12:27 AM by Myrna Larson	1	125
changing cells depending on another cell. by Skills Hi. I've dont it =VLOOKUP(Item,Q1:R6,2) However it does not seem to recognise anything begining with the letter c in the table, so if I type in car I dont...	October 3rd, 2004 08:41 AM by Trevor Shuttleworth	3	105
changing cells in multiple worksheets by boyd can i change a cell (say i9:) which is a date in 1-13-02 format to january 13, 2002 format in multiple worksheets within a folder	May 23rd, 2005 10:10 PM by Gord Dibben	2	99
Changing cells in solver. by Ricardo S. I'm using Excel 2003. When I try to solve a linear programming problem whit the solver, there is a message that says that there are too many changing cells....	October 23rd, 2006 03:31 AM by Paul B	1	72
Changing coler of tracking cells by marthajennings When I use "track changes" the changed cells are outlined in lavender which is really hard to see. Is there a way to change the highlight color to a darker...	April 7th, 2010 07:53 PM by marthajennings	0	142
changing color if value exceed speficied amount by What would the formula be so that if a vaule is exceeded it would change the color of the value. lets say if the vaule is 75% or greater you would want...	July 13th, 2004 04:27 PM by Andy B	2	129
Changing color of font in IF statement? by DrB Have a calculation for a cell using an IF statement. When true I want the calculated number to show up green; if false the font color should be red. Is this...	June 24th, 2004 12:51 AM by Juan Sanchez	3	109
Changing Color Palette by kaldon I know how to change the color palette. The problem is: changes do not stick if I open the workbook on a different computer. I am working with a macro and...	April 4th, 2006 01:28 AM by kaldon	2	93
changing colors of font in functions by andreee hello I would like to change color of font when value of cell is over 10000. Should I do it using IF function? How should I write it? What commands use to...	January 2nd, 2006 12:13 PM by Arvi Laanemets	1	91
Changing colors of text with functions by samuel I have 2 columns of numbers. What I am trying to accomplish is if the number in the column on the right is higher then the number in the column directly to the...	June 14th, 2004 08:54 PM by Frank Kabel	1	279
Changing colours using formulae by Jeff Hi, I want to make a colour appear black if it's positive and red if it's negative, any ideas? Many thanks Jeff Andrews	May 12th, 2004 01:18 PM by	2	143
changing column data to row data by Hair loss by excel Hello I have a large spreadsheet of excel data formatted in colums when I need it in rows. Currently it is e.g., A K 1 A l 2 A m 3	November 28th, 2007 04:53 AM by JMB	1	65
Changing Comment Box Position - Any solutions? by Stilla Hello! I've tried every which way there is, but can't seem to get this right! On mouseover on the red triangles I'd like the comment box to appear to the...	January 16th, 2007 06:59 PM by Stilla	4	90
Changing conditional formatting based on seperate cell value by Matt Hi. We have set up our staff scheduling on Excel at work and we have used simple Conditional Formatting to change the cells to green highlight working hours.....	August 3rd, 2004 11:59 PM by Frank Kabel	1	421
Changing conditional sum format to "Sum If" by Gina[_3_] I am currently using =SUM(IF(Data!$E$2:$E$1700=2467,Data!$Q$2:$Q$1700,0)) But I would instead like to reference cell B2 of the current worksheet rather...	August 27th, 2008 05:27 PM by David Biddulph	4	133
Changing Content in one coulumn using given content in another by Colin Hayes Hi All I have a small puzzle. In one column , I have a list of various components , many of which appear multiple times. In another , I have a list of their...	March 28th, 2010 11:28 PM by Colin Hayes	4	177

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