Is there a way to find the following with one formula: NAME Score A1: Larry B1: 28 A2: Joe B2: 45 A3: Hugo B3: 25 A4: Jim B4: 42 A5:...

We are trying to workout a formula to do with weight loss. So far we have everything correct apart from one colum and thats column E Column B = Weight in Kgs...

Dear At this forumla " =ROUND(IF($I2="N",$F2*2,($F2*2)-$O2),2)" . I want the result as below. 1. Result = + is ok 2. Result = - show "o" Please advice how to...

Dear We have a excel file two column, one is word , one is value. eg as below. Column 1 Column 2 A 1 A1 2 A2 3 A3 ...

What is the correct formula to use when you are calculating the IRR for irregular periods of cash flow? Thank you.

I'm trying to average a group of numbers. I do not want to include the blank or zeros. I used the following to exclude the zeros but it is still including...

I have several workbooks that I would like to print at one time in a specific order. I know you can use report manager when printing different views on one...

Hello, I am designing a planning system using excel spreadsheets and want to be able to have a 4 month view , my problem is then how to get the months to roll...

I want a formula to do this if c2 = Holiday or Bank Hol then display 8 (in the cell im typing the formula) if not do another formula (on the info in c2)

I have several sheets, but not all sheets fill one page when printed. I would like to append those sheets that fill less than a page together, so when I print...

format the cell as mmmm dd"," yyyy will give the result, set it up as a custom format, Format Cells Custom (at the bottom of the drop down list box) set up...

i'm trying to write for a formula that will give a 0 (zero) value rather than "#DIV/0!" when 2 zero values are divided by each other. i tried to use the "IF"...

The function you should use is "=3DCOUNTA(range)" This=20 will count each cell that has any format of data in the=20 cell. =20 -----Original Message----- I...

Use the SUMIF function. This allows you to look in one colmn for a specified entry and sum a second column corresponding to the specified...

MY WORKSHEET IS READING THE FILE SIZE AS BEING MUCH LARGER THAN IT ACTUALLY IS - THERE ARE ONLY 7 PAGES YET THE FILE LISTS 130 PAGES. ATTEMPS TO DELETE...

Dear We have a excel file. I want create a report . Our worksheet information as below. 1. A column as 20 field , a special field type "YES" ( NOT ALL...

I am looking at a formula made by someone else and it has the ! in it. Please tell me what this means.

Hi, I am doing my GCSE at the moment and I have come up with a fomula to calculate the area of any polygon. My formula includes TAN but when I use the TAN...

A spreadsheet previously created changes a date entry to "=date typed in" and displays "01/00/00" no matter what format has been applied to the cell.