The windows menu does not contain the option for freeze panes (rows and columns)

Is it possible to have a formula in one cell fill a different cell? EX: A1: 1 B1: =IF(A10, , ) If so, what is the syntax? Thanks!

Is it possibe to figure out monthly credit card payments since the finance charges differ from month to month and the amount paid monthly may differ. Lets say...

All, a1:a1000 contains a list of dates including duplicates and b1:b1000 contains amounts. I need to calculate the average amount by day of the month. ...

Hi, My excel does not recognise a standard function such as =sumif(a1:a10,month(a10),b1:b10) or =eomonth(a1), whereby column A contains dates and column b...

i am tring to create a fromula to calculate a 401k contrubution if there is equal to or greater than 1 yr of service the contribution is 3%.

I'm looking for a formula that can give me the yes or no result in cell (I8) .. Basically if Training Due is past the current date, the cell (I8) would say...

Hi All, I am using the function and the output is "#NA" - there's obviously something wrong. I've checked the field are the same format etc. To test the...

I have a list of numbers, this list has positive numbers that are being write of by a same negative number, this is 156.35 to -156.35 I need to show all the...

end down does not work the same in a macro as id does outside of a macro.

Hello, Could anyone help me... When I enter a vlookup formula, the first matching value is found and displayed, is there any way of getting the formula to...

I have entered an "if" statement in excel to return true or false . Can I additionally change the cell fill colour automatically based on the Returned value eg...

I have a workbook where each worksheet name is the name of an employees (surname & initial), total of around 50 different names. Is there a quick way to sort...

I keep getting a #VALUE error when trying to divide two cells. They are both numbers with decimals. In the error, I click to "show calculation steps" and see...

How can I do this ? If d2=Refund then negate the value in e2. ie make it a negative number Cheers

When I put in a date 3/24/05 what formula do I put in to have it automatically changed tomorrow to tomorrow's date?

Excel only calculates the confidence interval for a population mean through the =CONFIDENCE() function. I want the flexibility to calculate the confidence...

My original question was posted a few minutes ago (scroll down to see) & I got the answer below but it didn't work....I'm about to SCREAM!!!! Can someone...

Desparately in need of help!!! What I am trying to do is find the conditional formatting that is going to highlight the "Not equal to" cells. In other words,...