|
|
can't roundup sum by
swell estimator
shouldn't I be able to roundup a sum? The only way I can do it is to first
convert the sum to a number and roundup the number. That means 2 columns and
I...
|
September 4th, 2008 03:48 AM
by T. Valko
|
3 |
77 |
|
|
scroll with arrow keys problem by
Accounts Diva
When using the arrow keys to scroll down a spreadsheet, I find the active
cell disappears below the bottom of the screen. I have to use the scroll bar
at...
|
|
1 |
65 |
|
|
Annuity Payments From A Present Amount by
JRR
I am trying to figure out how to use functions in Excel to calculate an
annuity from a present amount. Do you happen to know how I would do this?
For...
|
|
2 |
102 |
|
|
Please HELP!!!! by
Yitzhack
Hello again,
I’m working on a project where I need to calculate the hours missed per day
on a daily basis. The workbook needs to record every employee...
|
September 4th, 2008 03:28 AM
by T. Valko
|
8 |
93 |
|
|
Need help with a formula by
Nobody
I currently have a formula or function which is =SUM(B26-B17) what do I
add if I want the total to appear in red if it is a minus rather that a...
|
September 4th, 2008 02:00 AM
by JMiller
|
5 |
130 |
|
|
look ups by
chrisgoods
hi
im looking for a formula that will let me look up two values in one table
array and return one value.
For example: How would i look up a numerical value...
|
September 3rd, 2008 11:52 PM
by Max
|
4 |
148 |
|
|
Excel formula question by
Greg S
Is there a formula or function similar to DGET that returns multiple text
records for specific criteria? I have multiple entries from the same date in
an...
|
September 3rd, 2008 11:25 PM
by T. Valko
|
1 |
95 |
|
|
Please help with vlookup function by
JMiller
Hi,
I am trying to copy data from sheet1 to sheet2.
I cannot use the regular copy and paste function because if I make changes
on the sheet1, will not...
|
September 3rd, 2008 10:48 PM
by JMiller
|
0 |
76 |
|
|
View Locked Cells? by
Nick Jenkins
Is there a way to show which cells have been locked without having to check
each cell? I have a very large spreadsheet with multiple worksheets. There
are...
|
|
3 |
103 |
|
|
|
September 3rd, 2008 10:10 PM
by Spiky
|
3 |
116 |
|
|
Linking Question by
akemeny
In order to prevent excessive entries of the same information my company
wants to link a master account list to the individual lists that we currently...
|
September 3rd, 2008 09:52 PM
by Spiky
|
4 |
158 |
|
|
|
September 3rd, 2008 08:48 PM
by FSt1
|
3 |
147 |
|
|
Check number within a range by
djungst
I would like to check a number to see if it is greater than one number and
less than or equal to another number and if it is perform a calculation on
the...
|
|
2 |
118 |
|
|
|
September 3rd, 2008 08:43 PM
by TT
|
0 |
130 |
|
|
conditional formatting by
Anne
how do i write a formula for a cell that i want to format if the date entered
into the cell is within 7 days beyond a date in another cell.
--
Anne
|
|
1 |
84 |
|
|
|
|
2 |
82 |
|
|
|
|
3 |
175 |
|
|
Macro_AND function by
Aline
There is an formula I’d like to add it in a macro.
=IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N")
I want it to automatically fill up for the rest of row. ...
|
September 3rd, 2008 06:46 PM
by Aline
|
2 |
89 |
|
|
excel 2007 right click edit query by
Koppite412
Hi Folks
New to Excel 2007, seasoned at Excel 2003.
I have set up an ODBC query, run it in MS Query and returned the data to
Excel 2007. On my previous...
|
|
1 |
116 |
|
|
Protect cells by
Tag1948
I want a cell like "Name" be locked, but the cell next to it to be open for
entering a name. How do I do it?
|
|
2 |
94 |