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
Help with If statement to subtract time (follow up) by richard.littlewing
Hi all I am trying to subtract 24 hours from a time if it is actually over 24 hours, if not then show 0 my formula works for everthing over 24 hours but...
September 15th, 2008 06:39 PM
by Teethless mama Go to last post
5 79
exel formula for numbers to text by Arun
Kindly provide me formula for above subject . example given below eg: AED 1005.5 = AED ONE THOUSAND FIVE FILS FIFTY ONLY. etc
September 15th, 2008 06:33 PM
by [email protected] Go to last post
2 162
Help with if then function by taxman
I am trying to use an If function in a spreadsheet to check if a person is married or single and their taxable income is within a certain range then the tax...
September 15th, 2008 06:19 PM
by T. Valko Go to last post
2 83
Sales Report by Andri
Dear All, I have a database in sheet A. the fields such as Sales Name, Product, Unit Price, etc. (E.g. the database contains 100Records, where Sales Name are...
September 15th, 2008 06:18 PM
by Andri Go to last post
7 99
September 15th, 2008 05:40 PM
by David Biddulph Go to last post
3 70
Need Help to Select certain Data from my spread sheet. by Gmata
Hi, I need some help to figure out a way to select certain data from my spreadsheet. Here is what i need. I have an inventory of diferent items each has...
September 15th, 2008 05:00 PM
by Spiky Go to last post
3 100
IF formula returning a colored cell by Jim Peterson
Hi everyone and thanks in advance for any help you can offer. I am using XP Pro and Office 2003. I want to form an IF formula that will look at the data in...
September 15th, 2008 04:58 PM
by Jim Peterson Go to last post
4 76
Formula Needed by Mark
I have two worksheets named "Business" and "Information" In "Business" there are three columns. Column A has dates in dd/mm/yy format going through to...
September 15th, 2008 04:48 PM
by Mark Go to last post
2 74
Gathering Count by date by Versace77
Good afternoon: Currently working with a column filled with various dates. I'm looking for a way to have a function written to count the amount of lines...
September 15th, 2008 04:47 PM
by Spiky Go to last post
4 133
SUMPRODUCT or SUMIF and INDIRECT, with Relative cell refs by Greg in CO[_2_]
Hi All! I have two worksheets in the same workbook: ProjectA DepartmentA In DepartmentA, in a cell for January hours, I want Excel to go to ProjectA, look...
September 15th, 2008 04:41 PM
by Greg in CO[_2_] Go to last post
5 189
Average values in date range by sarahg
Hi I have a list of numerical values (P5:P200) in O5:O200 is a corresponding date as to when the values were recorded. How can I calculate an average of...
September 15th, 2008 04:31 PM
by Gaurav[_6_] Go to last post
5 88
SUMPRODUCT....and then some! by Greg in CO[_2_]
Hi All! I have a SUMPRODUCT formula that is working, but I would like to streamline it from a maintenance point of view. Here is the...
September 15th, 2008 04:18 PM
by Greg in CO[_2_] Go to last post
6 108
3 LookUp Variables One Result by Iona
Hello Excel Geniuses, It is ending day and I am ready to go home... and want to wish everyone a great weekend! I am trying to find the most effective...
September 15th, 2008 04:04 PM
by Iona Go to last post
2 91
Help with a formula and cell referencing. by Jorge
Hello, I am currently working on a spreadsheet that was handed down from someone else and I am having trouble understanding one of the...
September 15th, 2008 03:38 PM
by Dana DeLouis Go to last post
3 103
protecting cells by password by Hardeep_kanwar[_2_]
you areHi! All Expert Is it possible to protect five or six cell with a password. I mean to say if somebody edit or type in these cell excel ask for a...
September 15th, 2008 03:29 PM
by Hardeep_kanwar[_2_] Go to last post
2 63
DELET PERTICULER WORD FROM THE EXCEL SHEET by Amit
I WANT TO KNOW THAT HOW CAN I DELET ONE SINGLE WORD WHICH IS MENTIONED IN DIFFRENT DIFFRENT CELL BY CLIKING ONE TIME OR BY SOME FORMULA....PLEAS LET ME KNOW.
September 15th, 2008 02:43 PM
by HARSHAWARDHAN. S .SHASTRI[_2_] Go to last post
2 88
The FV function by Jolanta
This is a silly question but I can't get it to work I put 1000 dollars in the bank (one time installment). I get 4% annual interest. And I keep the money in...
September 15th, 2008 01:21 PM
by stew Go to last post
8 81
Find top 5 highest values/percentage within a table by Tobias
Hello! I have two different excel sheets. In one of them, I have a big table of around 40-50 names and percentages. I want to find the top 5 highest values...
September 15th, 2008 12:39 PM
by Bob Phillips[_2_] Go to last post
2 83
subtraction issues by wes graham
OK, I need to keep a record of weight loss, entering one weekly weight at a time. The only formulas I can find only subtract all the cells at once. I need to...
September 15th, 2008 08:23 AM
by Roger Govier[_3_] Go to last post
2 53
#NAME? error for no apparent reason... by Monomeeth
Hello I'm getting the #NAME? error and I'm at a loss. I have the following formula in cell D4: =EOMONTH(D1,0) Now, the value of D1 is limited by a droplist...
September 15th, 2008 08:22 AM
by David Biddulph Go to last post
4 144
Post New Thread


Display Options
Showing threads 20381 to 20400 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:05 PM.


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