I have a graph which draws a line Rotations vs Time.
I want to make a cell where I can enter any amount of rotations and then
return the time in to another cell. Problem is it's not an easy relationship
between rotation and time.

I have credits in c2 and debits in f2 and the running total in h2 but I do
not want h2 to display anything if there is no number in either c2 or f2. I
have an idea it should look something like this
=If (c1 and f1="","",(h1-c2+f2)) but this does not work and I am not sure

When I open the edit menu I'm unable to select the link feature it is not
bold like the other options.

I am just learning how to use Data Validation in an online college course I
am taking.   My assignment is to set the Data Validation to warning and then
deliberately enter invalid data to set off the warning. Then I am supposed to
use the Formula Auditing toolbar to hightlight ...

Can anyone please help with writing a macro to check the following:
If sheet1!a4:af4 <> sheet2!a4:af4 then
msgbox("error")
Thanks

I have a sheet with numbers in three columns.
I would like to have a formula or function to
look across the row and tell me if there is a
consecutive number. In other words:

I ahve a spreadsheet were the first name and last name are in sperate colums.
I can join combine the two and copy as a value. When I combine them though
there are several extra spaces. Does anyone know what causes this and how to
fix it? here is an example:

Hi, What I'm hoping to do is to copy the =Hyperlink(A1,B1) result onto
a new cell with the actual linked text, but without the formula.  So
if A1 has "http://google.com" and B1 has "link", then rather than
using the above formula (which will read the same on the cell), the

I have got a column of data like below:
B
B
A

I would like via a function (preferred) or macro, to combine several
adjacent cells into a single cell, but separate the contents with a line
space.
I am familiar with the concatenate function, but I am unsure how to insert a

I have a range of data in column A1 to A10000, which has values ranging from
1 to 500.  I want to find the sum of the values which are between 400 and
300.
Any help would be appreciated.

I am trying to add a prompt for a date to make my external data pull from a
certain date only does anybody know how to do this.  I am pulling from a SQL
Database and have to have a date prompt or I exceed the row limits set in
excel.  I don't think it can be done but wanted to ...

Excel 2000
Is there a way to write a SUMIF formula such that one sums rows that
do NOT match the criterion?  Something like:
=SUMIF(A3:A1000,NOT("Total*"),C3:C1000)

I want to create a form/template that an end user can open each time and have
a unique number appear in a field.  Would like the number to be incremental,
if possible.

I have a series of single digit numbers and single alphabetic characters.
Each stands for a different corporate title. How do I convert the numbers and
alpha characters to the appropriate title -- 1=Owner, C=CEO, etc.