I'm sure this is simple, but I can't find it anywhere. I have the diameter of a circle and want to calculate the circumference. What's the formula?

I need a formula that produces only positive numbers or zero

Is there a formula for date that will automatically add the slash marks in between the numbers?  For example in my date column I want to type in only numbers (i.e. 011704), however, I want it it show up in the cell as 01-17-04.  If anyone knows how to accomplish this I would ...

How do you add hours on a time sheet?  I'm trying to come up with a spreadsheet where my employees can type in their time in's and time out's throughout the day and Excel will add them up daily and weekly.  I am able to add the hours in a day but when I try to add up the hours ...

I have a workbook with 4 tables:  times1, times2 & times3 are tables of data
to be referenced.  The 4th table named SECURED uses the formula:
"=IF(ISNA(VLOOKUP(TRIM($C53&E$51),times1,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53
&E$51),times2,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53&E$51),times3,1 ...

Is there a way to enter an NPV formula for a constant
stream of cash flows over the life of an annuity without
inputting each stream into the formula? That is, is there
a shortcut to determine the NPV of an annuity that pays

I am tying to setup a spreedsheet which would have
multiple individual lists of phone numbers and i want to
be able to compare these lists to each other. Example  
when a number in list A equals a number in list b then i

first time posting for help in the new group - looking for
formula for timetable creation. have never done timetable
prior to this. (see below)
Column A    

I am tying to setup a spreedsheet which would have
multiple individual lists of phone numbers and i want to
be able to compare these lists to each other. Example  
when a number in list A equals a number in list b then i

I used to use Works and could "freeze" column titles so
they printed on every page of my spreadsheet.  In Excel I
can't find anyway to do that.  Any help would be greatly
appreciated.  Thanks!

I have a workbook to track employee expenses
Sheet 1 i have...
in cells A8:H8 the following headings
Date, Item Description, Quantity, Currency, "Unit

Hello can anyone help me...i'm desperate trying to find a quicker way to this task: I have a worksheet where i need to add addition formula's into each row and then have the same formula repeat it self in a downwards direction into the same column...for e.g. = D7+F7+H7+J7(in one ...

I have a look up table with the user names in  column a and
their userid  in column B .  If the values in column d matches any
userid in column B then return the name of the user.  I've started with
the  function below and it works fine if the values  in column d are

I'm experiencing a problem I can't figure out. My workbook has one sheet that is strictly data, and all the other sheets depend on it. The automatically calulate option is turned on but the cells do not always update when I change the data in the main sheet. Frustrating because ...

I know the Hot Fix is out, but this is a Provable Workaround
The following is based on a VERY large battery of tests using up to
130,000 cells at a time.
1.    The percentage of negative numbers generated by Rand() varies