|
|
FORMULA, DAYS WORKED TO VACATION DAYS by
John5835
How would I do it the vacations are a little different, i.e.
after 1 year of work they receive 5 days vacations
for the 2nd, 3rd, and 4th year, vacation days...
|
|
2 |
85 |
|
|
|
July 31st, 2008 09:21 PM
by Spiky
|
1 |
97 |
|
|
if formula by
John5835
I'm trying to create a formula to calcuate vacations days, onee cell has # of
days worked and I want another cell to calculate # of vacations by # of days...
|
July 31st, 2008 09:20 PM
by Mike H
|
5 |
89 |
|
|
Pop Up Message by
chickalina
I want to create a popup message for orders over a certain amount. We can
generally process purchase orders up to a certain value without a quote.
Anything...
|
|
4 |
108 |
|
|
|
July 31st, 2008 09:06 PM
by tech1NJ
|
4 |
154 |
|
|
Averages by
Paige06
I need to average a row some cells have 0's but I need to include them in
the function so it averages correctly. The formula I currently have is...
( 1 2)
|
July 31st, 2008 08:50 PM
by Paige06
|
16 |
271 |
|
|
Min Values minus 18 months by
Elizabeth
I want to do this formula only 18 months instead of 547.5 days so it gives me
exact dates instead of ballpark? Does anyone know...
( 1 2)
|
|
13 |
148 |
|
|
Filter on more than one cells (text) by
Filtering more than two items
i want to filter cells for more than one value and i dont want to do every
time manually. like currently from the filter drop down manue I am selecting
each...
|
July 31st, 2008 08:39 PM
by Spiky
|
2 |
77 |
|
|
Another Cool Macro by
carla 7
S.O.S, help needed badly…the following macro:
For Each Worksheet In ActiveWorkbook.Worksheets
i = i + 1
If i ActiveWorkbook.Worksheets.Count Then...
|
July 31st, 2008 08:09 PM
by carla 7
|
0 |
80 |
|
|
|
July 31st, 2008 08:01 PM
by RagDyer
|
17 |
191 |
|
|
Difference between 2 cells (growing column) by
Stumped???
I have a column of numbers, that grows one cell per day. I need to find the
difference between the previous day's cell and today's cell. The formula I
use...
|
|
1 |
105 |
|
|
Lookup formula? by
Kelly
Hey all, I have a list of dates that occur every other saturday for the next
year in excel:
7/26/08
8/9/08
8/23/08
etc...
I need to look at a cell that is...
|
July 31st, 2008 06:43 PM
by Kelly
|
2 |
91 |
|
|
Returning a value based on a query by
Gail
Hi.
What function would I use to look for specific text in a cell, i.e. Rescind
or Cancel, and return the value R or C in a designated cell?
|
|
7 |
104 |
|
|
Networkdays to open previous day's file by
Dave
Hi,
I am trying to use the networkdays function to open a previous day's file. I
am receiving an error that the function is not defined. Why do I need to...
|
|
3 |
87 |
|
|
|
|
4 |
99 |
|
|
|
|
2 |
95 |
|
|
Using LARGE function with criteria by
TT
I have 2 columns of date. One with text and another with related numeric
figures. I am trying to craft a formula which will extract the largest nth
figures...
|
July 31st, 2008 05:39 PM
by TT
|
3 |
96 |
|
|
Find Function by
Jeff Gross[_2_]
I am using the following formula to search for a "" in a cell and then trip
off all text after it is...
|
|
4 |
82 |
|
|
iferror by
Roy Gudgeon[_2_]
Hi Guys
I am currently using office 2007
I have a large spreadsheet that uses the following formula:
=IF(G5/51,F5/g5,g5/f5)
This produces a "div/0" error...
( 1 2)
|
|
13 |
187 |
|
|
count if with multiple criteria by
Bertha needs help
I a worksheet i have a list of different alarms on column D. Then on column C
it states if its an "In" or "Out" alarm. So, I want to count in a different...
|
July 31st, 2008 05:18 PM
by RagDyeR
|
5 |
101 |