|
|
excel formula by
Angie
Does anyone have an excel formula for working out a loan
that has a balloon payment at the end?
|
|
1 |
70 |
|
|
|
|
1 |
126 |
|
|
FORMULA NEEDED by
Angie
IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES"
iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS?
iF i JUST HAD A LIST...
( 1 2)
|
November 3rd, 2008 11:05 PM
by Pete_UK
|
13 |
113 |
|
|
|
May 15th, 2008 10:15 PM
by Angie
|
5 |
103 |
|
|
Sumproduct with If by
Angie
I hope someone can help me. How can I sum the products of columns A and B,
but only if the value in column C meets a certain criteria (like = 51)?
( 1 2)
|
July 16th, 2008 09:42 PM
by Marcelo
|
17 |
82 |
|
|
Timesheets by
Angie
Im really hoping someone can help me on this.
I have created a timesheet that records hours worked no problem. But with
also have flexi time in our job so I...
|
|
3 |
70 |
|
|
sum function by
angie
i want to sum only filtered records in my worksheet. is that possible?
with the sum function this does not work. could i use another function?
|
February 6th, 2009 09:21 PM
by Marcelo
|
3 |
70 |
|
|
Hyperlink button is greyed out. by
Angie
I am working in Excel 2003 and I have a worksheet that is a table of contents
with links to PDF's and Word documents. I opened up the worksheet and now
some...
|
|
1 |
81 |
|
|
Excel worksheets won't all print by
angie
I have an inventory that starts with a summary page and is followed up by the
individual inventory types. I have always been able to print all the...
|
|
1 |
170 |
|
|
Unsorting after save by
Angie
My co-worker sorted the "client #" column, without sorting the rest of the
worksheet; then freaked and saved it. Without having to re-enter all of our...
|
November 8th, 2007 09:26 PM
by ilia
|
5 |
70 |
|
|
Macro Help by
Angie
Can anyone please help with writing a macro to check the following:
If sheet1!a4:af4 sheet2!a4:af4 then
msgbox("error")
Thanks
|
|
2 |
63 |
|
|
Equal to or less than formula by
Angie
I have filter media that I need to order every week and some filter medias I
have too much of. I need a formula that can tell me the exact date I need...
|
|
3 |
112 |
|
|
Active windows "overlapping' by
angie
I would like to have all my active window shown separately instead
overlap in one active window ?Any clue?thanks
|
|
1 |
63 |
|
|
lock only one cell by
angie
I'm trying to lock only one cell by first unlocking the entire sheet, then
locking only the cell, and then protecting the worksheet. However, when I do...
|
July 21st, 2006 06:08 PM
by angie
|
4 |
66 |
|
|
Formulas with multiple IFs by
Angie
I have an excel file used to track specific personal information for a group
of people who work for me. I have a column for date of birth and in a
separate...
|
|
3 |
66 |
|
|
Data Validation by
Angie
Is there a way to copy data to a sheet and retain the data validation
criteria for the cells in that sheet? When I copy the data into the sheet it
overrides...
|
June 1st, 2007 03:13 PM
by Angie
|
2 |
84 |
|
|
Writing IF Statement by
Angie
Is there anyway to write an if statement for a range without identifing each
cell?
Ex: If cells A1:AA1 = "test","proceed to next sheet","stop". ...
|
June 5th, 2007 10:10 PM
by Angie
|
4 |
59 |
|
|
|
June 5th, 2007 10:53 PM
by Angie
|
0 |
62 |
|
|
|
|
1 |
66 |
|
|
|
|
1 |
136 |