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
calculating commissions for a range of values by abryan
Hello, I have read the threads about similar problems on this site, but nothing seems to work for me so perhaps I am doing something wrong. I need to...
November 26th, 2005 07:01 PM
by bpeltzer Go to last post
2 83
Can I add a percentage formula to an IF statement? by abs
I would like to me able to add percentages to an IF formaule allow for a margin of error, say 10%. If anyone knows a way round it be much obliged. the cell...
September 20th, 2006 02:48 PM
by Teethless mama Go to last post
4 72
How do i add up every other coloumn in a linked sheet by abs
I am trying to add data in every other coloumn for my HR dept which is broken down my ethnicity and grade and want to excllude white and need the figures for...
October 9th, 2006 01:09 PM
by Roger Govier Go to last post
1 68
using a pda with excel by [email protected]
hi, i am new to this group, i would like to use excel on a pda is this possible thanks Bill
December 27th, 2007 09:22 AM
by David Biddulph Go to last post
3 100
If Then Formulas by ABSOLUTEMUSIC
I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE...
October 9th, 2003 10:23 PM
by StarTrek an beyond Go to last post
6 197
Sum If ??? by abuckeye
I want to sum column C if Column A is greater than or equal to 1/1/06 & less than 2/1/06. Any sugguestions?
May 31st, 2006 07:57 PM
by Bob Phillips Go to last post
4 72
How do I protect cells or a range of cells in excel spreadsheet? by Abundance
I need users to enter some data into an excel spreadsheet I have created. But I want to protect some cells so that the formulas and other information within...
July 28th, 2009 11:03 PM
by Rajesh Mehmi Go to last post
1 115
Conditional Format Font Color for more than 3 conditions by abusymomforever
A B J K 7 Date Store # Date Store # 8 9 01/01/2009 1122 10 ...
February 23rd, 2009 10:48 PM
by abusymomforever Go to last post
3 102
Sum a column that contains if statement that reference cells with by abusymomforever
I have tried every fx, combination of functions, formulas, etc and nothing seems to work. Here is what I have and please someone tell me how to get a...
(Multi-page thread 1 2)
February 24th, 2009 07:17 PM
by T. Valko Go to last post
13 213
Getting around the Invalid reference Error by abxy
Is there anyway to have excel "let" you enter an invalid worksheet or workbook reference? Everytime I enter an invalid reference Excel won't let me move on...
February 19th, 2004 10:07 PM
by Bob Umlas Go to last post
1 324
Counting cells between 2 values by abxy
Basically, i'm trying to count the number of cells that have dates between 1/1/04 and 1/8/04, but all the cells that are being counted are in one colunm in...
(Multi-page thread 1 2)
February 7th, 2004 06:54 AM
by Harlan Grove Go to last post
11 329
Printing only what can be seen by abxy
Ok, I have a worksheet or template rather with about 200 rows (each row size 14 font), each row (after the 7th row) has the same conditional formats and...
January 11th, 2004 03:08 AM
by Dave Peterson Go to last post
1 136
Autoformatting...kinda? by abxy
Ok, I've created a worksheet with some alternating shaded rows using conditional formatting and formula is: =MOD(ROW(),2). and I've customized some cells (the...
(Multi-page thread 1 2)
January 12th, 2004 10:43 PM
by Jonathan Rynd Go to last post
10 180
Converting date to text by ac
I would like to create a unique ID by combining Name & birthday. For : Abc Def birthday 1/1/08 I would like it to read ADef010108. I can get everything...
March 11th, 2009 07:26 PM
by Teethless mama Go to last post
2 101
Worksheet went grey! by AC
Working in a 3-sheet workbook, the worksheet I was at suddenly went grey. There are nothing to see, not event the grids. I can copy what was on the sheet...
February 5th, 2009 12:18 PM
by Max Go to last post
1 120
sumif with 2 ranges and multiple criteria by AC
I need help figuring out how to sum a range if I have multiple criteria in 2 separate columns not next to one another. This is what I have but it's not...
November 7th, 2008 04:26 AM
by T. Valko Go to last post
2 137
How do I calculate a weighted median? by ac
Anybody know how to do it in Excel?
June 25th, 2008 07:09 AM
by Harlan Grove[_2_] Go to last post
6 96
How can I remove a constant from a cell? by ac
I have a spreadsheet that has been updated and now sent to me for formatting and formula auditing but along the way someone entered in a constant variable...
April 29th, 2008 07:48 PM
by ac Go to last post
2 102
Cannot check the check mark box in cell by ac
I created the check mark box, renamed it, and then saved it off. I basically want to use it for a survey, but when I go to click on the box; it highlights...
February 15th, 2008 11:24 PM
by Gord Dibben Go to last post
1 70
LOOK UP AND SUM by AC
I am trying to look through a list on names in one column and values in the column next. If I have a name that repeats I want to add all the corresponding...
September 9th, 2009 06:16 PM
by Teethless mama Go to last post
2 125
Post New Thread


Display Options
Showing threads 1001 to 1020 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 12:43 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.