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
Set column function to round to nearest hundredth by
How do I get an entire column to round to the nearest one hundredh dollar?
September 25th, 2003 03:25 AM
by Ron Go to last post
2 209
font size & length of data validation by
Excelperts! Is there any way to increase the font size of the data in a data validation list AND is there any way to lengthen the box so you can see more of...
April 20th, 2004 08:56 PM
by Go to last post
2 114
Do I use an IF function? by
Here is what I'm trying to do. I'm making an expense record chart. I am entering a negative (-) number for items paid with a credit card and a positve (+)...
June 12th, 2004 01:25 PM
by Frank Kabel Go to last post
9 69
Formula is sending me over the edge by
This formula works when 47780 is input into D8, however, it does not work if C,P or 53S is in D9: =IF(OR(AND('Appendix...
June 25th, 2004 07:52 PM
by Harlan Grove Go to last post
4 53
Blank Cell by
Hello from Steved The formula below works, =HOUR(IF($T$40.5,$T$4-0.5,IF($T$41/24,$T$4+0.5,$T$4))) &TEXT(MINUTE($T$4),"00")) but when I add...
June 25th, 2004 10:27 PM
by Steved Go to last post
5 78
Watermarks by
Does anyone know how to make watermarks? By this, I mean, if I have a template already made up, and I want to put it into a binder of other documents, I want...
July 21st, 2004 04:46 PM
by Ron de Bruin Go to last post
1 126
Percentages by
I have several percentages in a drop down validation box. I'm trying to put 23.5% in using one decimal place. It shows as 23.5%, however, when you choose it...
September 2nd, 2004 04:04 PM
by Don Guillett Go to last post
1 45
Indirect References - Summarizing sheets - Relative? by
Hi all - Hoping anyone could help on this problem I am seeing. I have a workbook called SummaryForecast and have several sheets in the book: Summary; DeptA;...
September 2nd, 2004 08:28 PM
by Frank Kabel Go to last post
1 57
IRR by
What is the correct formula to use when you are calculating the IRR for irregular periods of cash flow? Thank you.
September 8th, 2004 11:10 PM
by Kevin H. Stecyk Go to last post
1 79
SUMIF cells in column contain specific month by
Assume that column A (rows 2-7)has dates in it and Column B (rows 2-6)has $ amounts. I want to sum the amounts in Column B for those rwos where the month in...
April 8th, 2004 12:49 AM
by Go to last post
3 83
Is anyone bright enough to help? by
Let me clarify. I am trying to transfer data from an excel 2002 cell to a specific place in a word 2002 document. I am not trying to cut/copy and paste. I...
March 12th, 2004 03:13 AM
by JulieD Go to last post
5 89
Help with a formula. by
I am trying to simplify a formula on a worksheet that sums the same cell on 50 other worksheets all within the same workbook. I can do it the long way of...
September 25th, 2003 04:43 AM
by Go to last post
2 74
sorting and combining data by
I've got two different spread sheets with large amount of data. These two charts however share one grout of data (in this case street address) The first set...
October 6th, 2003 01:22 PM
by Bernie Deitrick Go to last post
1 73
Linking Error : produces a "0" by
I am trying to link information from our main office copy to our invoice copy so that when you enter the Co. information, etc that it transfers over. I have...
October 22nd, 2003 09:16 PM
by Go to last post
1 70
AARON by
can AND be put into an IF statment to make two arguments. Like If C2=C3 AND B2=B3 ,B3=0,... any suggestions
December 19th, 2003 12:39 PM
by Ken Wright Go to last post
5 67
3D formulas to pull across worksheets by
I have six workbooks with about 75 tabs each. I want to return the same values from each of the different tabs, consolidated on to one tab. Right now we are...
December 20th, 2003 11:44 AM
by Ken Wright Go to last post
2 107
formula needed by
Hello, I have a spreadsheet that calculates our attendance, time off, overtime etc. and I need to count the following: If ST1 OR ST2 OR ST3 (this stands for...
January 28th, 2004 10:22 PM
by Biff Go to last post
5 70
Got me stumped by
I have an Excel Report that was generated by ODBC. I was asked to customize the report so that company numbers on one sheet would look up into another sheet...
March 11th, 2004 07:21 PM
by CMG Go to last post
2 50
Data transfer2 by
Let me clarify. I am trying to transfer data from an excel 2002 cell to a specific place in a word 2002 document. I am not trying to cut/copy and paste. I...
March 11th, 2004 11:32 PM
by Frank Kabel Go to last post
1 79
excel workbook acting weird by
I have an excel workbook that I converted from text. When I create formula in a cell (A1*2) it just displays the formula and not the result. I checked the...
September 16th, 2004 03:10 PM
by Go to last post
6 112
Post New Thread


Display Options
Showing threads 161 to 180 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:40 PM.


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