IF and Then Formula Help Needed Please
Wed, 27 Aug 2008 09:27:01 -0700
I need some assistance. Here's what I'm trying to do:
I have a column with years of service for all our employees, say it's column
D. Column E needs to say what their accural rate for vacation time is
depending on their length of service. So if the years of service is less than
3, accural is 4.62. If it's ...
|
Copying Named Range
Wed, 27 Aug 2008 09:05:02 -0700
there seem to be a lot of postings to do with Named Range Copying ... but I
have not found a simple answer to this...
I have a set of named ranges (data1, data2 etc) on one worksheet.
On a second worksheet in that workbook I want to be able to insert a copy of
the named range by simply 'pasting' the named rang ...
|
Multiple IF Formula Question
Wed, 27 Aug 2008 08:57:02 -0700
I'm looking to do the following:
If C5=1, -C21*12.50%, IF C5=2, -C21*15.00%, IF C2=3 and so on all the way
until IF C5=10.
Thanks.
~~Rob ...
|
Macro - How to not copy blank criteria?
Wed, 27 Aug 2008 08:45:38 -0700 (PDT)
Hello all,
I have a macro, which is designed to take a Data sheet and then filter
on a column. With this Criteria i want it to distribute to the
indiviudal tabs, adding that data to the bottom.
It works fine, as long as there is something for each criteria.
If, however, one of the criteria is blank, it will ...
|
Reference a number from one cell in the text of another cell?
Wed, 27 Aug 2008 08:46:01 -0700
I would like to setup the following:
cell A1: 2009E
cell A2: =A1 earnings per share
cell A3: =A1 net income
Such that cells A2 and A3 read: "2009E earnings per share" and "2009E net
income". The purpose would be able have various cells throughout a template
that cannot be grouped into a table that explic ...
|
Replace Link
Wed, 27 Aug 2008 08:40:02 -0700
I have 83 workbooks with 5 sheets per book and 21 links per sheet - and I
need to replace - (basic link - ='C:\Users\Annette\Desktop\Annette Daily
Weekly\Daily\August\[1Charge Sheet.xlsx]Mon'!$B$12) - I need to replace the
month in every link. I know I can go page by page with find and replace but
I woul ...
|
Finding a calculated Value across Columns
Wed, 27 Aug 2008 08:13:01 -0700
Hi
Does anyone know of a formula that will display the cell reference of a
given value? Basically I have a schedule running across 4 years (Columns) and
demands for various parts. I have total requirement and stock level calls:
I'd like to be able to say "Find the cell where the Sum of a.....x column is
g ...
|
|
|
lookups
Wed, 27 Aug 2008 07:46:01 -0700
I am trying to compare 2 different listings to see if any in list 1 is a
client. My lookup will only return the client if the client is an exact
match. How can I make the lookup return any variation of the name
This is my normal lookup:
=IF(ISERROR(VLOOKUP(A1,'clients'!$A$1:$B$200,2,FALSE)),0,VLOOKUP(A1,'cl ...
|
nesting sumproduct with subtotal
Wed, 27 Aug 2008 07:44:01 -0700
morning all,
I have a worksheet that I'm attempting to analyze, and wanted to see if a
nested sumproduct with subtotal would work. I.e., the idea made sense to me
but the application of it failed.
I've tried the following, and neither work.
=subtotal(109,sumproduct((RangeA=Criteria_RangeA)*(RangeB=Criter ...
|
LOOKUP/IF Formula Help!!
Wed, 27 Aug 2008 07:44:00 -0700
I have ben trying to write a formula that will deliver a response based on
where the inout fits within a range.
In short, say Cell A1 = 95. Based on that value, Cell A@ would house a
formula that would then LOOKUP the value of a specified cell base upon its
A1's placement within a range - B1 is for values 8 ...
|
