When I reference a blank cell, the result is "0" but I want the result to be blank as well. Is this a formatting issue? Example: A1 is blank my formula for...

Hello, Is it possible to split contents of a cell based on if the cell value is greater than 10000000, if true the result would be 1,000,0000, if not copy the...

I have a merged cell that spans from B:7 to B:18 (on worksheet named, OperatingRevenue) and I am trying to get that text to display in another worksheet...

Dear All, Great forum - hope someone can help with this. I have data in same workbook, different sheet arranged in cols with assigned NAMES to ranges. For...

I have created a table from Cell C1:I25. I want to enter amounts($) into each cell, hit enter and move to the cell below. After I have enter cell C25 I would...

I want the dynamic values in a cell to show until midnight and then like Cinderella convert to its value only when the clock strikes 12 midnight i.e. when the...

How can I sort dates by the month instead of the year?

a cell contains "123 a b". i want to unstring it into three cells in the same row.

I have tried using PULL from Harlan Grove's posts to workaround this but am coming up with #VALUE errors. Here's what I have: Column B contains the acct #...

I would like to do the next: If the value of a range of cells (e.g. b1:x1) exceed the value of a single cell (e.g. A1), cell A2 has to be marked by a color....

Is there a way to change the tab color of a worksheet if a certain cell has one value or another? "If cell value is more than zero then tab color is green"...

I wish to use a formula or to format a cell value so as to only display certain characters of the actual value. For example in the case of a...

I have created a spreadsheet that mirrors my paystubs, ie salary and deductions in column A and the dates of each payperiod listed B2:AA2. The dates are...

Hi there, I have a slight problem that I hope you may be able to help me with. I am trying to perform date validation to some cells in a worksheet, so it...

I need to compare data on 3 separate worksheets but all in same column to see what data is identical. What is the best technique to use?

I made and invoice excel template and a shipper excel template. Each time I open the worksheet to make an invoice, I want the number to change in the cell on...

My question revolves around summing particular items in a column based upon the number meeting 2 criteria. I have done this before with the sumif function for...

I am trying to make my daily cost report form into a functional excel spreadsheet, but i am having trouble with embedding the functions. Please help. Thank...