Sorry I am new to excel. The formula I need is to know how to put these two formulas together so that they work. =b1-b2 =if(b2=0,0) Thanks for any help

I want to how to put a formula for the beow requirement. sum of two cells, if i get a postive asnswer I want to display it, if I get a negative answer i...

Hi I do the ladder for the darts club I play darts for and have a webpage that has all the fixtures and results of all the teams for Monday and Wednesday night...

Hi I'm still having problems with the ladder, I get a problem with teams won drawn and lost not adding up correctly. Any one help please. Regards...

When setting up a "table" I repeatedly used the merge & center function. I want to expand and edit the table but the merge & center button is not functioning...

How do convert an int value of seconds past midnight into a time value? Example: 53100 = 2:45PM

Hi, I know about the ACCRINTM() function in Excel which returns the Interest-Accrued between the Issue date and the Settlement date at a given Rate ...

Is there a way to protect the Excel workbooks so that users cannot create links to external sources when they enter data?

I work on a lot of different budgets in excel. I want to know if there is a "draft" template or form that would show the word "draft" all over the budget. So...

Hi, I am using Excel 2007 and have a table that has 205 columns and 15 rows. I want to copy the data of the 15 rows of every column under Column A with a...

A few months ago I had asked a question and got this answer: Question: I have a a set of values in A1 through A100. I need to look up each value and find a...

A few months ago I had asked a question and got this answer: Question: I have a a set of values in A1 through A100. I need to look up each value and find a...

I have a simple formula (A1*B1*C1)/((A1*B1*C1)+(D1*E1*F1)+(G1*H1*I1)). However there are times when the values of D through F or the G through I denominators...

I need to satisfy the following condition: If the longest side of a box is greater than 60 or its second longest side is greater than 30, then charge $8. I...

Hi, I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C...

Hi, I have a a set of values in A1 through A100. I need to look up each value and find a match in another set of values located in C1 through C200. If a...

Hi, I appreciate if somebody can help me with a formula. In one spread sheet I have a list of products and their weights. In that same sheet I want to...

Hi, I have a list of references in column A going from A3:A240. I need a formula that can find a specific reference within that range and give me back the...

Hi, I appreciate if somebody can help me with a formula. In one spread sheet I have a list of products and their weights. In that same sheet I want to...

Hi all, I need help! I created a dropdown menu using Data Validation and a dynamic range, so that anything typed into the range automatically appears on the...