I get a #VALUE! error in L1 using this formula if H1 is blank. Any suggestions? =(J1*0.01*(IF(K1="",TODAY(),K1)-IF(H1="",E1,H1))/365+G1) E F G H ...

1Q I have a fairly big workbook importing and storing web data. 9 random of my webqueries aren't refreshing when I open the workbook or in the 10 min gap...

I am trying to setup formula that does the following, What did I miss? if data sheet,column T = k1 and data sheet, column T =k1 and Data sheet column B =...

i started to suse microsoft suite and my arrow keys move the entire Excel sheet instead of moving only the active cell frame (or highlight) How can I cahnge...

Hello, I have some data that I need to count based on two criteria. The tab name for the data is "nd". The first two characters of column B shows the market...

Hi I am facing very weired issue... we built a model in excel 2003 around a year back... one of my team mate moved to version 2007 and he enhanced the model...

Sorry if this has been asked before. i didn't find what i was looking for when searching this forum. I would like to create a button to print a worksheet but...

How do I compare the results of a formula with the text in another field? Example: I have a formula that is calculating a date (mm/dd/yyyy) in cell A1. I...

How do I compare the formula result in one cell with the text in another cell? I have a formula calculating a date in cell A1 and want to compare that to the...

I am trying to set up a workbook with a lot of pages which need to be indexed? How do I do this/

I have written a couple of VB subs that compose and send an email reminder from an excel application consisting of three sheets. Sheet one is a table which...

I'm having a problem with automatic calculation. It is set correctly in OPTIONS and I haven't opened a previous spreadsheet that was set to MANUAL (as one of...

OK so I want to use the SEARCH function but to look for the contents of one cell in another. Example |A|B|C| 1|orange|an orange|(my formula) 2|apple|an...

I need help to place information that is in multiple columns with 6 rows into a SINGLE column to place in our DATABASE... I know about TRANSPOSE, but I don't...

Hi, A B C D 1 150 300 450 600 2 2 20 50 70 80 3 4 40 ...

We are very puzzled about the amount of time it is taking to open Excel spreadsheets containing links to other spreadsheets. We have been attempting to...

I have a spreadsheet with a filter using "contains". I want to be able to update one cell with new "contain" criteria that will automatically filter the new...

Sir, I'm using Excel 2007 and have and I had one excel with around 250 sheets but today I deleted all the sheets except one sheet by mistake. Can I recover...

I have a dropdown list on page 1, with numbers from 1 to 10. I have the dropdown linked to the cell underneath (eg A1). If the number in the dropdown (and...