Hello from Steved
ok I am no thinking straight
What do I need to do please to have  a number in a row 1 to 40
as an example below

Could anyone help with this formula?
http://www.neilcarden.pwp.blueyonder.co.uk/bonus%20scheme.xls
I want to work out the percentage of a salary based on a targe
achevied or not. Please have a look at the example.

I want to count the number of times the data in column a =913 AND the value
in column c is <=999.  I only want to count rows in which both conditions are
true.  Countif only allows for one condition so how do I accomplish this?

In Excel 2000 (and earlier), this example.
     A     B     C      D
1    1     1^2  1^3  2.3
2    2     2^2  2^3  4.2

I have data entered into 2 separate databases:
DB A: roll_num, plate_date                 (step 1 of process)
DB B: roll_num, cut_date, cut_num     (step 2 of process)
cut_num is unique for every data entry, but the roll_num stays with a

I've got a couple of formulas for doing in single step:
B                A
A                B
F                D

Rather than typing in the $ before and after the cell reference, you can
hold down a key while clicking on the cell.  This shortcut inserts the $
before the letter and number of the cell reference.
My question is...what key do you hold down?

I'm stuck big time and I'm not even sure how to explain it ... but her
goes.
I need to use a formula that takes two different people, add all thei
transaction for a 30 day period, then subtract that amount from

I have two columns a nd b.  I have numbers in both columns.  I need a formula
to compare both columns and idenify the amounts that are not the same in both
columns.

Hey all, hope you can help with these two minor things.
Question 1:
Is it possible to:
In a contest between 2 people, first to reach 100pts.

im looking a formula
i have in column a, a list of numbers goig down, none are repeated bu
there are blanks in between some cells. i would like to list thes
number in column b in ascending order with no spaces.

I get send spreadsheets with supplier numbers on them, i.e. 256. i wish to
change these to 0000256, as all our account numbers contain 7 digits.
I know i can do this by either putting a ' before the number or changing the
cell to text, however i wish to change all numbers in a ...

When extracted to Excel, many reports from SAP do not come in a clean table
format but they appear with blank cells.
For example:
Column A       Column B    Column C   Column D

hey guy, got a question!
i got six main types of repair and under the six main categories, there
are ten
sub categories. now, i want to create a drop down box that will show

Is it possible to use a look up function for the data below?  I am trying to
return the data in the percent column based upon location, month, and
currency.  For example, for location KH, month 11, currency CAD the function
would retrieve 63.  Thank you for your help.