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
Calculate number of days by Linda P.
I am using Excel 2000. I need help with a formula. In A1 I have # of years, in A2 I have # of months and in A3 I have # of days. In A4 I want to add A1...
April 27th, 2010 04:29 PM
by Linda P.[_2_] Go to last post
7 316
April 27th, 2010 02:45 PM
by Glenn[_6_] Go to last post
1 163
Ctrl V paste coding was lost by peanut40
I wrote a macro and coded it to ctrl v which overwrote the paste function on the Ctrl V shortcut key, how do I replace the paste function coding? Or where...
April 27th, 2010 02:37 PM
by Jacob Skaria Go to last post
1 185
Modify general format to date format. by SherryS
When importing from payroll, it gives me all dates formatted as general numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to convert these...
April 27th, 2010 01:34 PM
by Teethless mama Go to last post
2 176
how do I double check that there are no formulas by 2468NICKIL
Hiding in an excel spreadsheet :o) Thanks
April 27th, 2010 12:49 PM
by trip_to_tokyo[_3_] Go to last post
2 198
error alert for invalid date by nader
hi I want excel showes error alert if user enters invalid dates like "2010/2/29"... I can not creat it on data validation.
April 27th, 2010 11:51 AM
by nader Go to last post
2 192
Cell Formatting of a Conditional Statement by RobFJ[_4_]
I want to be able to change the background of a cell colour if a second condition is met - but for the background to remain unchanged if the first condition...
April 27th, 2010 10:44 AM
by Ms-Exl-Learner Go to last post
3 167
Index using a defined name array by Swimmer1500m
I have defined 3 arrays using DefineNames: Boys_11_12 Boys_13_14 Boys_15_16 I then have defined a Combo dropdown with the following...
April 27th, 2010 09:21 AM
by Bob Phillips[_3_] Go to last post
1 184
excel: How to set up a formula for a range of numbers ie. 3.5-5.. by LadyK974
in a spreadsheet i have a range of numbers that needed to be counted ie. phos levels between 3.5-5.5 I can't find a formula to support this. Can you help
April 27th, 2010 06:31 AM
by David Heaton[_2_] Go to last post
3 226
Nested IF & AND functions by Stana1027
Trying to calculate bonus's for employees working 1 year, and based on their pay grade. Yet I'm getting #value, and Excel says I'm using the data type? help...
April 27th, 2010 06:23 AM
by David Heaton[_2_] Go to last post
4 196
Excel Formula for years and months by Newfie809
If the formula for number of years is =Year(latest date)-Year(earlier date) this formula only show the nubmer of years, and I would like it to show the...
April 27th, 2010 05:49 AM
by David Heaton[_2_] Go to last post
2 187
April 27th, 2010 02:42 AM
by Ashish Mathur[_2_] Go to last post
2 207
Can you AVERAGE IF and not null? by Spottkitty
=AVERAGE(IF($A$3:$A$45="Photo",H3:H45)) This is the array I'm using to try to determine an average. Problem...if the field is blank it's counting it as zero...
(Multi-page thread 1 2 3 ... Last Page)
April 26th, 2010 11:48 PM
by Hijosdelongi Go to last post
51 2,047
Vlookup by jacki
What is the best way to be able to enter a number into a cell and it returns the name that corresponds with that number in the cell to the right of it. The...
April 26th, 2010 11:12 PM
by UKMAN Go to last post
6 240
INDIRECT reference or ? by Tom
Excel 2007 all MS updates I need to search ANY column of numbers, say Column AL, to determine if any of the values are below or above a value that I'm wanting...
April 26th, 2010 10:34 PM
by T. Valko Go to last post
8 294
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible by Bumpersnesty
In my old computer with Excel 2003 if I select automatic calculation my spreadsheet updates stock price quotes from an external link. In my new computer with...
April 26th, 2010 09:44 PM
by Bumpersnesty Go to last post
0 207
Formula addition causes random #REF! by stevew
I have added a new formula to ledger worksheets and now the #REF! appears in areas in the workbook. In order to fix it, all I have to do is copy a good cell...
April 26th, 2010 09:05 PM
by Bernard Liengme Go to last post
1 176
Formula Help by jlo
In my "Total Days" column, I have the following formula and it works: E4 is Date sent to Vendor =DATEDIF(A3,TODAY(),"d") now, I want to add to this...
April 26th, 2010 07:23 PM
by Joe User[_2_] Go to last post
5 169
Satisfying two conditions? by Zuo
I need to satisfy the following condition: If the longest side of a box is greater than 60 or its second longest side is greater than 30, then charge $8. I...
April 26th, 2010 06:05 PM
by Fred Smith[_4_] Go to last post
8 177
what should be simple by Rene
b2 =min(g2,o2,w2,ae2) g2 =k2/n2 o2 =s2/v9 .... b2 works when all the cell formulas have data to compute, but does not work when one of the formulas returns...
April 26th, 2010 05:51 PM
by Bob Phillips[_3_] Go to last post
4 178
Post New Thread


Display Options
Showing threads 981 to 1000 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 04:26 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.