|
|
Formula help.... by
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:...
|
|
6 |
124 |
|
|
Formula needed by
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...
|
November 25th, 2005 05:07 PM
by
|
2 |
135 |
|
|
formula question by
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...
|
November 22nd, 2005 08:26 AM
by Max
|
1 |
131 |
|
|
formula QUESTION by
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 ...
|
|
2 |
75 |
|
|
IRR by
What is the correct formula to use when you are
calculating the IRR for irregular periods of cash flow?
Thank you.
|
|
1 |
118 |
|
|
Average by
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...
|
|
4 |
153 |
|
|
Printing by
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...
|
|
1 |
93 |
|
|
Planning system by
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...
|
|
1 |
108 |
|
|
Excel if formula maybe by
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)
|
|
1 |
95 |
|
|
printing several sheets as one by
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...
|
December 31st, 2003 03:58 PM
by Dan C.
|
1 |
294 |
|
|
Changing date format to text only by
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...
|
January 1st, 2004 07:37 AM
by
|
0 |
536 |
|
|
formula by
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"...
|
|
1 |
76 |
|
|
Problem Counting a Range of Numbers by
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...
|
May 17th, 2004 02:54 PM
by
|
0 |
296 |
|
|
|
May 17th, 2004 03:58 PM
by
|
0 |
146 |
|
|
WORKSHEET CONCERNS by
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...
|
|
1 |
115 |
|
|
Formula Help!!! by
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...
|
February 27th, 2006 11:49 AM
by
|
4 |
123 |
|
|
|
|
1 |
100 |
|
|
|
December 15th, 2005 08:43 PM
by MrShorty
|
5 |
155 |
|
|
|
|
1 |
86 |
|
|
|
April 8th, 2005 02:51 PM
by bj
|
1 |
93 |