|
|
Excel formula by
David franklin
I need some help Please. not sure how to write a formula? Description of what
I want.:
if cell is equal to 48 or less then I want to add 3 to the cell but...
|
|
5 |
156 |
|
|
trouble getting a formula to repeat rows by
FoulDwimmerlaik
Thanks in advance to all your help.
I have a formula I'm using, =(C1*3)+(E1*5)+(F1*3)+(I1*5)+K1, and I need it
to repeat at the end of every row and...
|
|
5 |
104 |
|
|
EXTRACT MONTH FROM DATE by
SSJ
Hello,
I am using the following formula to extract month from the date:
=month(a1)
The result is 1
What I wan to see is Jan instead of 1.
|
|
5 |
230 |
|
|
Excel Ribbon by
Rhonda
This might have been asked in the past but I can not find a post about it. My
question is why is it when you click a command on the ribbon; for instance:...
|
|
5 |
157 |
|
|
Deleting multiple entrys by
Octet32
How can I delete multiple rows that have the same entry? Example if I filter
by a certain zip code can I delete all without deleting other info?
|
March 10th, 2008 02:03 PM
by Gordon
|
5 |
135 |
|
|
Help with a multi if then else formula. by
Pank
I have the following scenario for which I would require one formula which
would be in cell E25:-
A numerical weight amount is input in cell A25.
If the...
|
March 13th, 2008 10:31 AM
by Max
|
5 |
242 |
|
|
How to reference an active cell by
Tomá¹ Vognar
I've recorded a simple macro for Excel, where I work with a row. But I want
to work with a row the active cell is on, but Macro Recorder has writen me
an...
|
March 14th, 2008 08:56 PM
by JP[_5_]
|
5 |
123 |
|
|
|
|
5 |
118 |
|
|
Another sorting question - easy one! by
Terri[_2_]
Finally figured out how to sort my information but this is my next question.
Everything is sorted alphabetically by the first column (Name)...when I
enter a...
|
|
5 |
167 |
|
|
auto date insert by
bry25_uk
i'm using office spreadsheet which is similar formulas to excel i believe. I
want it to automatically insert a date when you open it on a certain day,
i.e.,...
|
|
5 |
141 |
|
|
HOW TO COUPLE VLOOKUP & SUMIF by
SSJ
Hello!
1) I have two tabs, namely, Tab 1 and Tab 2
2) Tab 1 has two headings, namely, "Work Order Number" and "Total". Underneath would be a list of work...
|
February 27th, 2008 03:43 PM
by JP[_5_]
|
5 |
129 |
|
|
Working out a rota....If function or time? by
R[_3_]
Column A is Names, B is H for Holiday (Mental reminder column) I have column
C (Monday) as a time for a person to work. IE: 09.30 - 12.00.
The next column...
|
February 7th, 2008 06:58 AM
by R[_3_]
|
5 |
108 |
|
|
Hiding data in a range of cells by
Dobbin0_4
I am seting up a spreadsheet that works like a bank statement, So from
ranges g 6 through g29 i have a balance figure. But i will be adding
transactions to...
|
|
5 |
191 |
|
|
How to hide day by
sureshift
I have this equation.
=Text(f1,"DDDD") Which comes out as 3/1/08 Thursday.
How do I get it to come up blank till I put in a date.
At the moment it comes up...
|
|
5 |
101 |
|
|
sum total by
marlenar
In a sum total column, how do I add more than one row at a time?
|
February 8th, 2008 11:20 PM
by Max
|
5 |
101 |
|
|
Help; ther's got to be a better way :-( by
nikki dawn
Hi,
I have several reports that export into .xls spreadsheeets from SAP. They
always export with multiple header lines which makes it hard to sort because...
|
|
5 |
172 |
|
|
Struggling with date formulas by
Bonnie A
Hi everyone. Using E02 on XP. I am trying to work some formulas and I have
the general idea what I need to do.
I have a date of birth and date of hire . ...
|
February 20th, 2008 05:30 PM
by Bonnie A
|
5 |
79 |
|
|
wildcard in IF function by
Nancy Newburger
Hi,
I need an alternate formula, preferably simple (I am an Excel rookie) for
the following:
{=SUM(IF(A19:A26"AD*", IF(A19:A26"SUB*",C19:C26,"")))}
The...
|
|
5 |
143 |
|
|
Question about lists ? by
le clef
Hello all
I use a drop down list to allow users of a worksheet to select customer names.
Is it possible to open the list and press the first letter of the...
|
February 27th, 2008 08:18 AM
by le clef
|
5 |
115 |
|
|
Showing Formulas by
trvlnmny
Is there some way to show the formulas used and their current values
in a report?
Thanks
|
|
5 |
121 |