what is ^ function could you please help with identifying what is '^' used for? ... 2 Feb 2010 17:31 Formula Help I am creating an invoice in Excel. I would like to be able to creat a formula that will enter an amount in say column B IF there is ANY text in column A. trying to use the IF function, I don't know what I could put into the "Logical test" box in order to have it accepted. After that, I would put my standard fee amount... 2 Feb 2010 17:31 How do you do an IF statement in Excel comparing three columns If I want column D to equal the highest number from column A, B, or C how would I write that formula? ... 2 Feb 2010 17:31 Establishing most common word in an Excel column Using Office 2003. In my weatherstation data, [very long listings over 12 months x 4 readings per day ], the wind's direction changes are listed as:- NORTH, NE,SE,SE,EAST,ENE,WSW,SOUTH,SE,EAST, NW, WNW, and so on. I would like to find a formula that will tell me the most prolific word in the column list. I ho... 3 Feb 2010 11:44 Print Dialog Box Not sure if this is possible in excel but can you create a box which you then enter a code and from a seperate sheet all the data gets printed. At the moment I write a macro for each code Thanks ... 2 Feb 2010 17:31 FIND A VALUE FROM CROSPONDING COLUM AND MULTIPLE CROSSPENDING ROW S.NO Name "Pay Date/Paid Date" A B 1 Zia 01/01/2010 2 03/01/2010 3 amir 12/12/2009 4 01/01/2010 Find the value for Zia (A1) from crossponding column B but row no 2 (B2) whch is " 03/01/2010" ... 2 Feb 2010 17:31 Count backwards N cells Hi all, In col.B I want a formula to count back from C1 times, cells in column A but to skip the blank and 0, and return row of first cell: A B C 1: 1 1 2 2: 0 1 3: 1 4: 0 1 5: -2 1 6: 3 5 7: 5 8: 5 9: 1 6 10: -5 9 11: 5 10 12: 0 10 13: 10... 2 Feb 2010 17:31 Count a value excluding duplicates depending on a set criteria Hi, hope someone can help, I have data that has multiple entrys for a date, but I only want to count each day as one using a formula in excel 2007. A B C D 1 Dept Crew Type Date 2 301 A 1 1/02/2009 3 302 C 2 1/02/2009 4 301 A 1 1/02/2009 5 301 A 1 2/02/2009 6 302 C 2 1/02/2009 7 303 D 2 1/02/2009 8 3... 2 Feb 2010 17:31 when i type 5 then it shows.006 hi all i am new to excel,i was making some sheet and when i type number 5 or any number it show.005,please let me know what to do ... 2 Feb 2010 17:31 fill color a protected cell without unprotecting worksheet ... 2 Feb 2010 17:31