When using the "if" function on the function wizard, I'm having problem
with penny rounding. I have three columns. Column 1 is a net figure, an
column 2 is sales tax, at 17.5% and these two cannot be changed.   In m
third column I have put in a sum to check that column 2 is 17.5% o

How do I set up an accounting package for use with a small charity operating
in the UK

I have this conditional format in cell BB35
=IF(BB35>$BB$37,TRUE)
If I insert cells between BB35 & BB37, then the
formula changes to =IF(BB35>$BB$38,TRUE)

I am trying to use sort function just to delete blank cells in between
Sort order doesn't matter actually.
Data is coming by the use of simple cell reference of "another sheet
--

i want to make a list in excel from 1 to 100, i have read many help file's
but i can't get it done.
Is here someone here to help out?
All the best,

what do I do so a will get  "0" if the answer is less than zero such as  5 -
6 and it give me "0"

Is it possible to reach a goal in a cell, modifying the values in more than
one cell?

I am using Excel 2000.  I need to copy a name that is located on Sheet 1
cell A5 to a certain cell on Sheet 2.  I was hoping to put a formula in my
Sheet 2 cell that would automatically place the name there for me, but so
far I haven't been able to get anything to work.

I have two spreadsheets saved as seperate files with different names.
One is sheet is called parcels.xls.  The other i
Parcels.Sales.Update.xls.  
parcels.xls is a master record of all properties in the county I liv

in order to record pupil achievement I would like to change the fill colour
of any cell in a worksheet by clicking in it once with the mouse.
Can anyone tell me how I go about getting Excel to do this please.
Cheers

I am frequently importing data from other applications, into Excel 2002
workbooks.  There are, many times, blank rows, with no pattern or in no way
similar to the last import.  
I am eagarly seeking help in creating an automated process to delete all the

Never used Excel for this but I know it can be done.

Here is a nice easy one!
I have a value in a spreadsheet that I need to check.  If the valu
<-0.005% or >0.005%, then I need to notify the user that an adjustmen
is required.

I was wondering if someone could help, I'm writing a case select wher
the first case is <50000, and the next one is between 50000 and 250000
I can't seem to figure out how to do between 2 numbers with a cas
select.

Hi, I input "1/4" or something like that, actually, it's a string, but Excel
is to smart to change it to Jan 4, 2004. I would like to know how to stop
this automatic change? What's the code to do so? As I am actually using VB
code to operate Excel.