I did asked ppl to tell me the alternate (Formula/Func Blah blah) of PrintDate for Excel Since In Excel I can't find it.... And ppl told me to use =Now() and...

Back in the old Lotus 123 days, I remember being able to use #AND# or #OR# in a condition statement. How is this done in Excel? For example, if I wanted to...

Hi Guys, I've been working on this off-and-on for the last couple of days with no success. What I have is a worksheet where users enter information that...

If cell M6 is less than 37.5 then calculate the difference.

I am trying to create a scheduler and need to find out the hours worked in a given day. For example, I worked from 9:00 AM to 5:30 PM with an hour break. I...

I'm trying to create a formula that says "if the value in A1 is greater than 5 and less than 10" return a "1" otherwise leave blank. note: column A are all...

I have a formula =MAX(0,37.5-M9) and I need the cell to show blank if the answer is 0. What can I change?

I'm looking to see if there's any way that I can SEND information from cells on one worksheet to another. I'm running into some problems with one sheet TAKING...

I want to set up a Sports Draw for 6 teams. If I list the teams and add the weekly dates, can I have Excel use a formula to insert the team names?

We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5...

Is there anyway to use this function to enter only the filename and not the full path?

I am having trouble looking up the Text (String) in the list the contains the same text (string) For example, one list contains "Sam Smith", and the other list...

I am creating a scheduler but am having problems figuring out the amount of time between 6:00 PM and 12:30 AM. It would like it to return a figure of 6.5...

Does Excel have a "sigma" function . . . i.e. I want to sum all the values of a formula over a range of values (z = 1 to n). Ideally, I would like to do this...

I get a #value in my total column W12, the formula is: =SUM(W11,U12,-V12) the formula in the W11 column is the same. The formula in U12 is: =+N12, the...

Suppose I have two columns of data. Column A is the independent variable, say TIME. Column B is the dependent variable, say SPEED. The data are collected on...

I have a set up an XL costing sheet but I want to send all/part of the results to another sheet, HOW? Not forgetting I'm a "self taught numpty" with no-one to...

I am creating an accounting spreadsheet in excel 2003. One of the sheets is all the inventory that we use. One column has the product, the next column has...

Hi; I am in the process of building a home and i would like to keep a running total of the expenses vs the budget we have set. Can i make a formula that will...

Hi, I have sheet: In A column exist date In B column exist "x" or null In C column please bulid formula: first or last day in month only for day if in column...