Functions

Negative result gives #### is there a way to show the actual - num
Terry That doesn't happen because you have a negative number. It's because the column is not wide enough to hold that number. Increase the width of that column. HTH Otto "catts22" <catts22(a)discussions.microsoft.com> wrote in message news:EE982E7F-74EE-403E-965A-389B4708587E(a)microsoft.com... Hi ... 27 May 2010 10:23

Compare between 2 worksheet
Hi, Could any one show me how I can compare two worksheet to find out if there are any difference. The 2 worksheet might contain data like Name in column A of worksheet 1 and column D of worksheet 2. Age in column C of worksheet 1 and column E of worksheet 3. Thanks in advance. Terry -- Message post... 26 May 2010 08:04

If greater than 5
Need a formula - I know it's simply - just can't get it. If A1 is greater than 5, then B1 = 5 If A1 is less than 5, B1 should equal the amount in A1 CarolAnn ... 27 May 2010 22:33

Is there a way to "glue" a matrix rectangle of cells together?
The cells would only be moved as a group, but could be detached from each other at some point. ... 27 May 2010 17:04

Hour function equivelent help
If I want to find out how many minutes there are for times that I have summed, I know I can use the hour function if the compiled time is less than 24 hours. But, what if I want to get the times that are over a 24 hour period, how do I do that? Example: 20:57:46 14:39:10 8:57:24 12:12:12 ------------- 56:... 26 May 2010 09:09

Array formulae do not recalculate
I have a large number of array formulae in my sheet. I update the supporting data and the formulae do not recalculate. The only way i can get a recalc is to F2 and then ctrl+shift+enter. How can I get all of the formulae to recalc. Manual recalc does not work. ... 26 May 2010 04:50

linking a sales receipt worksheet to an inventory worksheet
I have a sales receipt worksheet that has all my sales items on it. I also have an inventory worksheet. I would like when I make a sale that it automatically is deducted from my inventory worksheet. I have Office 2003 Example: Sales receipt is (sheet 4) In each column Item#-Description-Item Cost-Qty-Cost Exampl... 25 May 2010 16:53

Function to add name of Sheet to a Column?
I am preparing to merge sheets in a workbook, before I do I need to find a way to pull the sheet name into ColumnX so once merged I will retain the categorization. Is there a simple formula I can paste/fill-down into a column to do this? Thanks in advance ... 25 May 2010 17:59

RANDBETWEEN generating numbers outside range
Using Excel 2003. Simple task of trying to generate a pseudo-random number between 1 and 52 (yes, a deck of cards). I'm populating the cells with =RANDBETWEEN(1,52). Many of the cells are displaying negative numbers. Any ideas? ... 25 May 2010 17:59

returning a text value
I think this is simple but I am confused with it. I am creating a softball roster. Column a is the positions, Column b is player for inning 1. C is inning 2 and so on. So with my current grid I can see who is in which position by inning. My second grid will show players name followed by position being played. ... 25 May 2010 15:47