I'm in need of the following:
a1=9
Formula:  If a1 is greater than 8, I need b1 to show 8 only.  If it is less
than 8, I need it to show the amount that is less than 8.

I want to type text in cells of one column in msexcell.
and i want to use characters like enter, tab, bullets..... just like that we
use in msword.
please help me.

I am a little new to formulas in excel and I need some help.
I have a large spreadsheet with about a hundred tabs.  The first 30 or so
tabs are individual info. then after that the tabs are grouped into accounts.
Meaning although they are still different tabs there are groups ...

I'm trying to add numerical data from 28 separate worksheets onto a "totals
sheet" (the 29th workbook) and cannot figure out how to create the formula.
What should I be using to create this specialized formula?  
For example on sheet one I want to run the totals from each separate

I am trying to make labels where the text is different in Each label. I am
having a very hard time getting the size of the cells correct. I need 3
columns & 3 rows in each label. That way, my company name and certain other
info can stay in each label, via linking, and the rest ...

I am using the EXACT function in column B to compare if information in column
A is the same as column C on a spreadsheet.  If it is not, I am inserting
cells above all the data in column C until I find a match with column A.  
What is happening is that the EXACT function seems to ...

I have a stock ranking system based on Excel, Every week I download 250 daily
quotes from some 300 funds into one long row. I then have simple formulas in
the top column (starting at G2) with the weekly and montly price changes
(this week's divided by last week's price, etc), and ...

I need to sort data alphabetically on a speadsheet and also add new data from
another excel spreadsheet. The problem is the column to sort is 4 lines
(column D) and the other columns with contractor numbers that need to match
and phone number data are spaced the same, however ...

I have three cells a1, b1 and c1 that should indicate green, yellow and red
respectively when values and range of values are given in say cell e1. The
values corresponding to the cells a1, b1 and c1 could be 100, 90 <=X<=95 and
<90 respectively. What formula should I use for each ...

i am working on a spreadsheet and need some help, it's hard to explain what i
want but i'll try my best, here goes! I have a sheet and on it i have several
amounts in different cells like this:-
20.36    19.36    17.24    17.54    19.81    20.12

I am quiet new with excel. Please can anyone help me with writing a formular
for a cell that contains a range of numbers. I the cell to for example
indicate red if a value in another cell is say between 90 and 100 and another
example that says for example

I have a spreadsheet which shows the date and mileage of business journeys. I
am trying to create a function that will for each month pick out the mileages
for that month and total them up.
Tried the following: =SUMIF(A19:A64,">=01/04/2006",G19:G64) where the A

I am trying to write a statement where if the values in column A equal a
certain value then it will combine the corresponding data in column B,
preferably separated by a comma.  So far CANCATENATE hasn't worked because I
haven't been able to get around identifying specific cells ...

What is wrong with this formula?
=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch
Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch
Log'!F2:F2001,0))

I can't seem to figure out how to carry subtotals from a specific cell in
each worksheet over to a grandtotal cell on the last worksheet. ie. cell O33
on worksheet1 + cell O28 on worksheet3 + cell O53 on worksheet 4 and so on.
Any suggestions?