excel

I have a drop down menu with Electricity, Gas and Coal as the options. I then want other cells to have certain figures based on what fuel source has been chosen. So in lay mans terms i would like cell C7 to =C14 IF C3 ='Electricity' OR =C21 IF C3 = 'Gas' OR = C28 IF C3 = 'Coal' C14 having the...

For example, I want to alphabetize a spread sheet but the names are paired with numbers that match them. So if I alphabetize it the numbers wont match the right person anymore, is there anyway to sort on excel without losing the correctly paired data?

please help me. "how is your current experience enable you to excel in the job you are applying now? i don't know how to answer this question, can u all please help me? thx!

I want to include the time in a block thingy on Microsoft Excel. I want it to be like 2 hours 5 minutes or even with it abbreviated would be fine. but I just want to know how 2 put that as a format so I would then be able to make a block that would add it all up for me.

Is there an Excel formula / trick to select all cells with a phone number? or "www."? I have Excel 2007. I pulled names from a directory but I want to delete the rows containing phone numbers. All numbers have this format: (###) ###-#### Yes, there is a space after the area code. Also is...

Is there an Excel formula / trick to select all cells with a phone number? or "www."? I have Excel 2007. I pulled names from a directory but I want to delete the rows containing phone numbers. All numbers have this format: (###) ###-#### Yes, there is a space after the area code. Also is...

Is there an Excel formula / trick to select all cells with a phone number? or "www."? I have Excel 2007. I pulled names from a directory but I want to delete the rows containing phone numbers. All numbers have this format: (###) ###-#### Yes, there is a space after the area code. Also is...

Is there an Excel formula / trick to select all cells with a phone number? or "www."? I have Excel 2007. I pulled names from a directory but I want to delete the rows containing phone numbers. All numbers have this format: (###) ###-#### Yes, there is a space after the area code. Also is...

Is there a way to enter two possible answers for quiz in excel? Hey there. I'm creating a self-assessing quiz in excel for my spanish class to study vocabulary, and I'm wondering if there is a way to insert a function to accept two possible answers. For example: If the question says to...

EG In my cells I have F1000 and F2000. I wish to be able to do F1000+F2000 = 3000 Thanks!

EG In my cells I have F1000 and F2000. I wish to be able to do F1000+F2000 = 3000 Thanks!

Inside my cells I have data such as F1000, F2000, F3000 etc. Is there anyway of adding the numbers that follow the letters ie F1000 + F2000 = 3000 Thanks!

Inside my cells I have data such as F1000, F2000, F3000 etc. Is there anyway of adding the numbers that follow the letters ie F1000 + F2000 = 3000 Thanks!

Im trying to help a friend out here with their spreadsheet. Im usually pretty good with the functions but i am stumped with this one and NEED help So, its an excel workbook with 5 spreadsheets. What im trying to convert into syntax for a formula is: If the information from all of Column k (...

ok, I'm making a drop down list. it says something like (present /absent) so if there the two options what formula can i use so that it totals everytime how many times you are present and how many times you are absent seperately.

ok, I'm making a drop down list. it says something like (present /absent) so if there the two options what formula can i use so that it totals everytime how many times you are present and how many times you are absent seperately.

ok, I'm making a drop down list. it says something like (present /absent) so if there the two options what formula can i use so that it totals everytime how many times you are present and how many times you are absent seperately.

I have to make a t-test bell shaped curve with a difference of means. I have both sample means and standard deviations. i just need to learn thow to do this on excel 2003.

Hi all, I want to add a leading Zero in a range of selected cells (not the active one), of course they have to be formatted as text. I have a solution but I want to see if there are any other solutions. Thanks.

The fire in the restaurant at the Excelsior building on May 20th left the gym out of commission—despite the fact there's no actual damage to the gym. The gym has been closed now for 16 days with no information made available to its members. Members have all paid-in-full for the month of May and...