|
|
Sum by
sgrech
Hi,
I have a following data in a column on my spreadsheet
0.00
-98.35
#N/A
-222.89
56.45
0.00
|
|
2 |
180 |
|
|
Penny rounding! by
rozbat
Gordon, the trouble is not that I can't do as you've suggested, the
problem is that almost all the columns are showing errors because of
the tiny roundings up...
|
October 23rd, 2004 04:17 PM
by rozbat
|
0 |
143 |
|
|
Changing values daily by
George Gee
I would like to know if this is achievable?
I would like cell B30 to show whatever is in cell F10
If the value in cell F10 changes, then the new value
to be...
|
|
4 |
296 |
|
|
Penny rounding! by
rozbat
When using the "if" function on the function wizard, I'm having problems
with penny rounding. I have three columns. Column 1 is a net figure, and
column 2 is...
|
October 23rd, 2004 02:24 PM
by Gordon
|
1 |
159 |
|
|
Conditional Formatting by
George Gee
Hi all
I have this conditional format in cell BB35
=IF(BB35$BB$37,TRUE)
If I insert cells between BB35 & BB37, then the
formula changes to...
|
|
5 |
169 |
|
|
combining columns by
mudraker
one85x
In c2 enter this formula
=right("b2",4) & left("a2",1)
--
mudraker
------------------------------------------------------------------------
|
|
1 |
172 |
|
|
|
October 23rd, 2004 02:40 AM
by Mark
|
1 |
185 |
|
|
Deleting Blank Rows by
PA
I am frequently importing data from other applications, into Excel 2002
workbooks. There are, many times, blank rows, with no pattern or in no way
similar to...
|
|
1 |
271 |
|
|
|
|
2 |
274 |
|
|
IF Function by
sgrech
Here is a nice easy one!
I have a value in a spreadsheet that I need to check. If the value
-0.005% or 0.005%, then I need to notify the user that an...
|
|
2 |
175 |
|
|
Uppercase Input by
L.A. Lawyer
I want to format a cell so that any characters inputted into that cell are
automatically saved as uppercase in that cell. How do I do that?
|
|
2 |
191 |
|
|
need more columns by
Herm
Have used up all columns and need about 60 more can I add then and how or do
I need to look at redesigning, can't rotate work as again still not enought
columns
|
|
1 |
142 |
|
|
update month itervals automatically by
Odart
If say something was done in May-04 and it's not due again for another 15
monthes how do I get excel to due the math and then when it get's done in 15
monthes...
|
|
2 |
154 |
|
|
macro cannot be found by
Ydiv
I created a macro and called it Timestamp_on_save. It was originally
supposed to populate a cell with the current time and date upon hitting the
'save' button....
|
|
1 |
291 |
|
|
|
October 22nd, 2004 08:37 AM
by JulieD
|
1 |
163 |
|
|
|
October 22nd, 2004 07:39 AM
by JulieD
|
1 |
149 |
|
|
Custom filters by
Dudley
I created a custom filter on a city field, looking for all cities that start
with So.
The criteria used was begins with SO. THis works fine.
I then...
|
October 22nd, 2004 05:50 AM
by VENKAT
|
2 |
184 |
|
|
Audits by
LMB
Hi Everyone,
I am using Excel 2000 and am a beginner. We are going to be doing some QI testing for our department in our hospital. We will be looking at...
|
October 21st, 2004 09:06 PM
by LMB
|
2 |
149 |
|
|
Displaying durations in Excel by
Verbatim
I have a worksheet which calculates a duration in hours...is there a built-in
number formatter that could display that as h:mm:ss? How would I create...
|
|
2 |
181 |
|
|
goal seek command function by
Mark
Can you give me an example of how to input value to get a specific result for
the goal seek function;i.e, what values do we input in the boxes to get...
|
October 21st, 2004 02:09 PM
by VENKAT
|
2 |
148 |