Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. ...
Summary: For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying inform...
Summary: Hi, Hate to bother every1, just have a quick question regarding a excel formula. Im using a lot of =sum formulas, i was just wondering in my total fig...
Summary: I have a spreadsheet that I need ot create a formula where the first column will be used to increase the total of second colum, third column will subt...
Summary: Need help with an Excel formula - EXAMPLE: Need to enter a formula into Cell C1 to multiply a number entered in Cell A1 (20,000) by the number in Cel...
Summary: Excel formula - because it is beyond my expertise can Excel do this: I want to post 3 scenarios on Worksheet A. User will click a check box or somethi...
Summary: I am hoping someone can help me create an excel formula. Column C is the result of column A time Column B. If the resulting value in Column C is les...
Summary: I am trying to write an excel formula for my work to easily track excessive absence's. I think this would be it... If the date inserted in the cell i...
Summary: Im trying to figure out how to write the blw excel formula. Anyone can help? For eg, If user enter cell A1 = 60 then cell A2 will auto reflect 40 and ...
Summary: I have created an Excel query in Office 2007 to return a specific set of values from within a named range in my spreadsheet (for example, the 6PM temp...
Summary: Hi there, sorry I'm new and I'm not very good at explaining complex excel formulas. I have uploaded a copy of my worksheet to my webspace and this is ...
Summary: Hi, You haven't said what values are in column B, but as you are using COUNT() which counts the number of cells containing a number (Excel help states...
Summary: Hello! I'm using Microsoft Excel 2004 for Mac. I am using it to calculate my payroll. I have a cell that I need to calculate regular pay for the we...
Summary: Hello! I have an Excel workbook in which there are 2 spreadsheets; sheet1 contains a vendor list – Column A – G | #, Printer Name, Address 1, Addr...
Summary: I am working with an Excel workbook that contains two sheets. On the first sheet, I have several columns of information about departments participati...
Summary: In Excel 2000, my worksheet, column A is consecutive dates and column B is meter readings, that increase daily. Since the meters aren't read daily, t...
Summary: Excel error: a formula in a cell (Name:[filename]worksheet!(Unititled) could not be converted because it contains a function that is not available in ...
Summary: I understand that it cannot be donw with a formula but it canbe done using VBA. See http://www.cpearson.com/excel/colors.htm for some good information...
Summary: Hey guys, I am creating an Excel workbook for keeping track of my bills. I have it all set except for one formula that is still giving me problems an...
Summary: I want to create a spreadsheet in Excel 2000 in which I enter my start time, lunch out and lunch in times and show the total hours as 8. I then want t...
Summary: I need some help with a formula in Excel 03. I have two Excel workbooks. The first WB is a financial report that I am importing data into. I am import...
Summary: hi jenifer, Ok here is what I want, hopefully this is more clear...... Comparing numbers in cells and returning 'True' if all the arguments are true, ...
Summary: I recently copied some numerical values from a web page to my excel worksheet, now i want to sum them all, whenever i use the Standard sum formula as ...
Summary: Hey, I am working on a quick spreadsheet for reporting for work, and everything works fine, except for 1 sheet, which i'm not sure how to do it! I'm n...