A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
IF Function by Kirk
Im trying to get a value from 6 cells. Im entering the if function into B2. cells C2, D2, E2, F2, G2 & H2 have either #N/A or the the answer Im looking for...
February 27th, 2009 09:47 AM
by Kirk Go to last post
3 109
how can subtact or add Week 07/2009 in one column & Week 10/2009 . by Pooja
pls let me about this quection...How can i add or subtract this from Week 07/2009 in one column & Week 10/2009 in another column.
February 27th, 2009 08:07 AM
by Shane Devenshire[_3_] Go to last post
2 77
question for multiply cells. by Robert
I'm trying to but together a formula that will take a score and assign a value of one if the cell is greater then the other cell but from a series of...
February 27th, 2009 07:17 AM
by T. Valko[_2_] Go to last post
2 84
Count formula by Mohill
I have created a budget spreadsheet and a exspense register. I have assigned each exspense an account number. How can I get the sum of all exspenses...
February 27th, 2009 03:56 AM
by T. Valko[_2_] Go to last post
3 81
Cell Locking Question by Wayne[_2_]
I have a feeling that this isn't possible, but I'll ask the question anyway. Is there a way to lock cells but allow certain information to be entered or...
February 27th, 2009 01:42 AM
by Elkar Go to last post
2 68
Table help Please!?!?!?! by Cook[_7_]
Template Tab B10= 1 of 5 recipe codes (PA7, AL6, etc.) Row A= Recipe items Row B= Quantity of recipe item Table Tab B1,C1,D1,E1,F1= Recipe Codes A2-A64=...
February 27th, 2009 01:15 AM
by Max Go to last post
1 155
Combining data from different cells and more... by Jeff
I have a worksheet in Excel 2002 made from a database. I have tried two methods to combine data from several cells in a row into a separate cell as...
February 27th, 2009 01:11 AM
by Elkar Go to last post
2 88
QUÉ FUNCIÓN by aNNABELLA
tENGO UNA COLUMNA CON LOS PRECIOS DE COMPRA Y OTRA CON LOS PRECIOS DE VENTA DE VARIOS PRODUCTOS. qUIERO AGREGAR OTRA COLUMNA DÓNDE ME HAGA EL CÁLCULO DE...
February 27th, 2009 01:05 AM
by aNNABELLA Go to last post
0 50
#VALUE! error when trying to add cells (VLOOKUP) by sandy
I am trying to add cells that have been filled with the VLOOKUP function. =SUM(F6+I6+L6+O6+R6+T6) Those cells have a value from a VLOOKUP...
February 27th, 2009 12:47 AM
by Ashish Mathur[_2_] Go to last post
8 143
In MS Excel 2003, need to do conditional formating on HLOOKUP by Shikha
I need to paint the result of HLOOKUP in red if it returns #N/A or #REF, but conditional formatting formula is not able to equate #N/A as a string. Anyone...
February 27th, 2009 12:42 AM
by Ashish Mathur[_2_] Go to last post
3 91
How do I keep a running total of people I contact as a percentage by uptight26
I need to keep a running tally of people that I contact from a speicific list (a total of 67 people) and I need to display it as a percentage. I would like...
February 27th, 2009 12:34 AM
by Sheeloo[_3_] Go to last post
2 73
conditional format by skc
i have used two of the functions but ii need to have a color to hightlight all cells that have parking, p, prk
February 27th, 2009 12:16 AM
by Sheeloo[_3_] Go to last post
1 57
workng bet wrksheets by Vashni
I am working on a project. I want to create a document where I input all the info required on sheet 1 and this is automatically entered to the rest of the...
February 27th, 2009 12:12 AM
by Sheeloo[_3_] Go to last post
2 80
Add certain cells given specific criteria by hcronrath
On sheet 1 Column1 is a date function that returns the number of months sales have come in, it is formatted as a number. On the same sheet in Column 2 I...
February 27th, 2009 12:10 AM
by Sheeloo[_3_] Go to last post
2 54
How can I return zero after a max value has been met? by hcronrath
The plan bonus should end once it equals the total growth bonus. Here is the formula that I use to calculate the Plan...
February 26th, 2009 11:20 PM
by joeu2004 Go to last post
7 158
add on date specfic by Curt
Am trying to have a amount added to a cell on a specific date (IE: 15) I want it to add to the amount all ready in the cell. =IF((M4=123),123) This gives me...
February 26th, 2009 11:08 PM
by T. Valko[_2_] Go to last post
1 59
Help with formula with Named Ranges by Corey ....
I have 3 Named Ranges in a Sheet Named("SavedData") as follows: ModuleNames =SavedData!$A$2:$A$200 ; NamesDone =SavedData!$D$2:$D$200 and ;...
February 26th, 2009 10:48 PM
by T. Valko[_2_] Go to last post
2 69
Count Uniques with a Couple Conditions by ryguy7272
I am trying to match names (with many duplicates) in a sheet2, with a list of names (no duplicates) in a Summary Sheet. Then for each name, count unique...
February 26th, 2009 10:44 PM
by ryguy7272 Go to last post
2 71
how to convert number to text by Medegypt
all of your answer did not help me i used text furmela not help who can help
February 26th, 2009 09:58 PM
by Mike H Go to last post
1 62
Count function without double counting by Yossy
I have following A B C D and so on 1a 20 30 1000 20 = 100% - no of times there were values in...
February 26th, 2009 08:20 PM
by ~L Go to last post
1 70
Post New Thread


Display Options
Showing threads 13861 to 13880 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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 08:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.