Can I use IF formula to ccmpare time? Ex =IF (A4=24:00:00, "24")

Hi! I've checked a few threads on this matter, but they don't quite cover what I'm after. I have an Excel document with several columns full of words and...

Hi.. I tried to reset the standard color in Excell 2007. When using Excell 2003, I usually find it in toolsoptionscolorreset in excell 2003. How do I do...

I need to set up a spread sheet to be able to get age, sex,service usage numbers, site utilisation, presenting issue e.g., drug and alcohol, region,...

I have a group of cells for an inventory sheet. I want to prevent double or incorrect entry. For example, if there is any entry into cell F6 they cannot...

Hello, I have a template that generates info in it from a access database. I would like to have a window come up as soon as the excel file opens and ask to...

I am charting monthly call volumes in a line graph in which I have 7 series (a different line of business). Each series takes 12 cells of data,...

how do i add a number to a range of cells? I need to add 11.27 to a number of different cells each with a different number in them

Im really new here so apologize if this has been asked before. My problem is this: I have created a template file that will be stored on a share drive company...

I am happily going along selecting certain cells with my mouse when, all of a sudden, a click of the mouse starts selecting five cells at a time. I don't...

Good afternoon folks, I'll try to keep this short. The formula i'm working with =-sum(c6:h6)+a6, is in cell b6. ? how can I enter a new value in a6 and have b6...

Hi I have a column of part numbers which are of varying length and start with varying letters. I would like to add 'M' to the beginning of every cell so for...

I can set up a conditional format in one cell. I would like to copy that CF to all the cells in the column. Any way to do that in 2007?

Is there an excel formula that will replace a number value with a line of text? Example if I type "1" into the cell it will be replaced with "final draft",...

Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter...

I would like to calculate a cumulative of: A1 = 3.2 B1 = 9.5 C1 = 6.9 I want D1 to be the result of the cumulative of A1, B1 and C1 only if they have a...

How to convert this type of numbers in one formula 1145 =1150 1141 =1150 1149 =1150 12458=12460

I need to calculate a date 10 days from a start date that, if the final date is a Sat, the result defaults to the previous Fri, or, if the final date is a...

I'd like to teach myself vlookup are there any online courses that will teach me or and courses i should take before attempting to learn this function?...

I have an Excel application that has three sheets Data, Work area, and display. Data = Data Work area = Formulas Display = Charts. When I change the name of...