I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS.

Hi, I need the fomula for below scenario, A4 = start date (exp.= 01.03.2007) B4 = end date (exp. = 31.05.2012) D1 = 01.04.2007 D2= 31.03.2008 E1= ...

Hello! I am having a hard time solving this problem. I have a spreadsheet with questions typed in the cells, then checkboxes, then a text box that when...

Hey...I am working with two worksheets in excel 2007. Sheet one named Data has all of my data ... each data row is like; A2-first name / B2-last name /...

Hello everbody, I have this little problem with a worksheet in excel. I was trying to make an alphabetic order ( from A to Z ). Than I noticed excel doesn't...

Hi I am using Microsoft Office 2007. And I am getting the problem that each time I write any link in Excel sheet, by default it converts it in to the...

Hey all, Basically, I have a last, first, and initial in column A, B, C respectively - a list of 1000. Then I have last, first in column D, E respectively - a...

Hi, I have an excel which has automatic calculations turned on and uses RTD to get Real time Data on the sheet. The sheet is updating all the time. Whenever...

Hi there, I had an Excel Macro program which was running very well in Office 97. But after I had upgraded my Office 97 to Office 2003, I could not run part...

Having trouble with formulas. I have two work sheets. Work sheet1 is a work order. Work sheet2 is what needs to be done by a certain date. What I need to do...

Office Version:Office 2007 Operating System:Windows XP Our organization has a hundred printer makes and models. We all use Office 2007, and we all print to...

I have just inserted a series of 8 calculated fields using sumproduct into a spreadsheet which references a closed workbook and have now been given the error ...

I saved a workbook with a digital signature, but now want to remove it so I can edit the workbook. When I try to remove the signature, signature is "invalid"...

Dear Members, I have two drop down list in the Excel sheet. say Country and State. If i choose value from Country, automatically respective state should be...

Hi, Whenever input data in one cell in a worksheet, how can Excel help to check if this entry (data) has never been input before after inputting the data, so...

Hi, I am hoping someone can help me with this. I would like to write a macro in Excel that copies the value from a cell, and uses that value to generate a new...

How do I safely and securely convert an excel file (xls) to a QIF or OFX file?

My company uses a program called PureEdge that enables users to click a simple "Sign Here" button and record a digital signature. The signature is...

How can i view 3 worksheets in the same workbook, tiled side by side in the excel window? Is this possible?

Can anyone advise how to make a simple report in Excel?? I have two columns of info that I need to group.. 1) Name & 2) Value I have over 10000 lines of...