|
|
Help with formula by
007juk
Hi,
I have created a spreadsheet but, have encountered a problem with the
formula or maybe the format, not to sure.
I have a workbook containing 5...
|
|
3 |
84 |
|
|
Question re Vlookup function within Excel. by
007juk[_3_]
Hi,
Can the following be done.
I have the following formula in Sheet1 of my workbook.
=VLOOKUP(B6,Sheet2!A2:BC499,5,)
When cell A2 of Sheet2 is populated...
|
|
7 |
88 |
|
|
Formula by
00mm00
I have a problem with formulas in Excel XP: they show in formula bar AND in cells (value of formula doesn't show in the cell). I guess it treats formula as...
|
|
1 |
88 |
|
|
Constant growth by
050529
The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount
cell)) is giving me result "num". The objective is to apply a constant
inflationery...
|
May 29th, 2005 08:17 PM
by PC
|
5 |
78 |
|
|
Printing formulas in worksheet by
05_CHASBRO
I have been able to display & print the results (values) of the formulas that
I have developed, but what I really need is to be able to display & print the...
|
|
3 |
69 |
|
|
Military time not properly calulated by
0be1
I have two cells that are set for h:mm and the time will switch throughout a
24 hour time period. For some reason ever fix I have tried, the time is still...
|
|
4 |
72 |
|
|
Formula help - rounding up and round down? by
0greeny0
Can anyone help me with working out a formula which automatically rounds data
up or down?
I am developing an assessment data base for my school and need...
|
February 21st, 2009 12:10 PM
by 0greeny0
|
2 |
60 |
|
|
|
|
7 |
93 |
|
|
Help with schedule by
0o0o0o0o
I have a schedule for 50 people with names in a column A and days of the week
in first row: each employee can be assigned to one of four duty stations, be
off,...
|
November 23rd, 2004 03:36 AM
by Max
|
4 |
154 |
|
|
|
|
2 |
87 |
|
|
Why is that happen ? by
0xC00D11CD
Hi,
i format all cells in D,E,F and G to currency and try to typ for example
1459.70 in cell D but it returns just this ########.
Can someone tell me why...
|
|
1 |
75 |
|
|
Any function to ... by
0xC00D11CD
Hi,
I would realy appreciate if someone can help.
Here is my question,
1) Is there a function if i type in a cell for example 500£ that it will
be...
|
|
1 |
58 |
|
|
Exist a function to... by
0xC00D11CD
Hi there,
i just started to use Exel 2003 and would realy appreciate if someone can
help.
Here are my two questions,
1) Is there a function if i type in a cell...
|
|
3 |
86 |
|
|
Graphs in Excel 2007 by
1 of 1
I am new in Excel 2007. In Excel 97' there was an option or using special
graphs which allowed you to have dual Y-Axis. You could then graph both $ and
%...
|
|
2 |
118 |
|
|
|
|
2 |
98 |
|
|
feet, inches by
100pinesfarm
HOW DO I INPUT FEET AND INCHES AND CALCULATE WITH THEM (I.E. +/-)
|
|
2 |
86 |
|
|
How to filter only the numbers I need by
10john01
I have a list of phone numbers, some of the numbers have multiple numbers
associated with them, some do not. When I autofilter, I see all the numbers
I...
|
|
3 |
64 |
|
|
Adding/Saving Combo Additems by
10_a_c
Hello:
I do not know if this is the corrrect group for this question but here it
goes. I can add items to a Combo Box either via the Box properties or in...
|
March 14th, 2007 12:10 PM
by 10_a_c
|
0 |
50 |
|
|
3 Time frame by
11050204
Hi all,
I have 3 different sheets with 3 different time frame (Daily, Hour, 5
Minutes). I would need a formula that would allow me to look for a set
time (5PM)...
|
June 27th, 2005 03:05 AM
by duane
|
1 |
183 |
|
|
|
|
1 |
70 |