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 Reverse Sort Order Last Post Replies Views
problem with our time cards. by 12345
we do not use excel to figure our time. we have time cards they punch the clock it does go to to miltary time. do you have to convert into hundreds to figure...
December 15th, 2006 05:59 PM
by Roger Govier Go to last post
1 61
password by 123456789
I'm forget the password for unprotect the *.xls files
September 28th, 2005 02:00 PM
by Bernie Deitrick Go to last post
1 61
Database functions should use criteria in formula, as 1-2-3 does by 123user
Excel's database formulas are primitive. They work like 1-2-3's database functions did in its Release 3. Instead of making the user create a...
September 29th, 2005 08:57 PM
by 123user Go to last post
8 286
Formula in a cell to calc FUTA tax by 12by8
FUTA tax maximum for W-2 employees is $56 based on first $7K of gross wages (7K*.008). At $7000.01, there's no need to calc FUTA. I have a wage sheet that...
November 16th, 2007 08:13 PM
by 12by8 Go to last post
9 59
Another Conditional Formatting Question by 1320_Life
I have 898 rows of information spread across 13 columns. Column "G" has dates (898 *different* dates...). What I want to do is set a conditional formula to...
July 22nd, 2006 10:05 PM
by 1320_Life Go to last post
4 89
Need Help with Formula by 1320_Life
I'm trying to create a formula that sums a number of cells (in column "L") IF the corresponding cells in column "A" are the same. For example: Company ...
July 22nd, 2006 02:35 PM
by 1320_Life Go to last post
2 62
Compound Interest Rate or Growth Rate by 1944-71222
Is there a function in Excell that can be used to calculate an investment"s compound growth rate? If so what is it and how do you use it? For instance if...
March 15th, 2010 05:38 AM
by Fred Smith[_4_] Go to last post
2 176
Weighted Average of positive and negative % by [email protected]
I have the following numbers and corresponding growth rates: A B 1 4197 7.90% 2 4114 8.30% 3 1885 0.50% 4 624 10.50% 5 ...
December 9th, 2006 05:10 AM
by [email protected] Go to last post
8 63
SUMIF with 2 conditions by 1990
Can anyone help, I have a spreadsheet with 2 sheets, the first sheet contains the data, the second sheet is a summary page. Sheet 1 contains 8 colums (a - h),...
January 4th, 2006 11:39 PM
by Kleev Go to last post
8 79
how to transport bold and italicized text from other programs by 1alaska
I am trasporting blocks of text from word to excel and need the font to remain the same as it was in its original form. How do I do that? There seems to be...
September 17th, 2007 01:30 PM
by Gary''s Student Go to last post
1 103
July 28th, 2009 04:01 PM
by David Biddulph Go to last post
3 89
Wouldn't know what to call it! by 1Fish2Fish
I have a "table" that I created. It's just a basic grid with items on the y axis and items on the x axis (ex. types of fruit on the top, number of fruit in...
August 26th, 2008 07:37 PM
by Don Guillett Go to last post
5 80
In excel, can I format a cell to automatically take the curser to. by 1google
Can I format a cell to have the curser automatically go to a different specified cell?
January 14th, 2005 07:07 PM
by Gord Dibben Go to last post
2 245
Matching Cells in different files to sum. by 1gr8tigerfan
How can I make an inquiry between 2 files where I want to search for matches in a column between the worksheets and then sum the appropriate data.
August 1st, 2007 01:26 PM
by 1gr8tigerfan Go to last post
2 111
how do I divide or multiply an entire column? by 1number
I have a price list that I need to convert entire columns by either dividing them or multipication. Is there a formula to do this.
March 5th, 2005 09:48 PM
by Gord Dibben Go to last post
4 185
How to update one manually-entered value from another? by 1robc57
I have a cell (E5) which represents a manually entered value "Inventory" (say 10), in J5 the user enters 5 to reflect "Damaged Inventory Discarded". I want E5...
February 2nd, 2006 06:07 AM
by 1robc57 Go to last post
2 87
Enter number on a worksheet to copy row from another worksheet by 1SG
I want to create data on sheet 2 of a spread sheet. Then on sheet 1 I type in a part number (123456) in B5. The search will go to sheet 2 find that part...
May 22nd, 2007 12:15 AM
by Pete_UK Go to last post
1 56
How do I remove unnecessary vertical page break? by 1smstewart1
I created a chart with 5 little columns. Excel took the liberty of inserting a very unnecessary vertical page break. The information quite easily fit on...
November 15th, 2006 07:09 PM
by Gord Dibben Go to last post
2 52
Returning a sum when looking up two different values by 1stcoast
=SUM(IF('Pernod'!$A$1:$A$7320,A7)+('Pernod'!$G$1:$G$7320,AC4),'Pernod'!$K$1:$K$7320) I can not get this formula to return an result. I can only get a...
April 17th, 2006 02:45 PM
by Ardus Petus Go to last post
1 54
My formulas return the formula not a result in the cell by 1stcoast
Cell A1 Formula in cell B1 00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16) The calculation returns the formula not a result. What am I doing wrong?
April 12th, 2008 10:14 PM
by IronMan Go to last post
7 160
Post New Thread


Display Options
Showing threads 441 to 460 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 10:29 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.