perhaps somebody knows how to do this:
in column A i have different values, for example:
   A    B
1  aa  

This is the type of data I have. The actual spreadsheet is 15 columns
by 100 rows.
A        B    C    D    E
Task 1        x    x    x

i would like 2 do the following,
if an person as done less then 36 hours all their bouns from 5 will go down
to 0.50
=<36hours (bonus/5), this times 0.50

I have a workbook filled with formulas and it takes time to compute
formula and open the workbook.
Is there a way I can stop the computation of formula when the workbook
is opened?

I'm a NEWB. Nice Forum.
I'm making a worksheet and I'm having problems with the "IF" function.
I'll explain what I'm doing and if you wouldn't care, please help. :)
I'm just making a worksheet of my domain portfolio. I have the "date

is there a function that if A2=12.76, another cell will =2?

How can i use a conditional formula to return one of 3 values ie. if A1 is
less than x return 10 if it is between x and y return 20 and if it is greater
than y return 30

How can I joing (merge) tables by key field like in DBMS?
Can't find any suitable solutions. Only by some stupid tricks, but I don't
like it and it's not handy to use...
Also found http://www.digdb.com/ add-in, but it costs money :)

How can I mass add a 0 to a field.
example: 544 = 0544  But I have about 2000 lines and I would like to mass
add them.  

Hi, I was given this formula,
=INDEX('Stock Req 3-8 Digi
BarCodes'!$B$1:$X$5,SUMPRODUCT(SMALL(ROW('Stock Req 3-8 Digi
BarCodes'!$2:$5)*('Stock Req 3-8 Digi

I want to write an IF-function, which inserts a picture in the worksheet. If
this is possible, please tell me how.
Tks

I can write functions in PHP & MySQL, but can't get my headd aroun
another language for Excel.
I have a spreadsheet with 2 columns for dates (B & C), a duratio
column (D) and a Yes or No column (E). We fill column B with the date

Here's the problem I'm asking help from the more Excel experience
forum users:
I have 7 tables with 4 columns: IP, BytesIN, BytesOUT, BytesTOTAL.
As you already guessed, it's about daily network traffi

I would like to create a worksheet working with Exponential Values
e.g. 1/2 +1/5 =2/5
So, I would like for the values to appear as I want them to be. I don't want
Excel to convert them e.g. 1/2 converted to 0.5

I have a three spreadsheets.  Each represents a different year and each has
one column with different dates within that year.
Unfortunately I entered all of these dates in the default date format  ie
7-jan and did not enter a year.  I now need to ensure the year is present in