|
|
IF THEN Statement by
barbara h
I need to do a calculation based on a cell. If cell B12 = 0, then I need
to calculate a formula (B13*.40). If cell B12 0, then value = 0.
Can anybody...
|
February 11th, 2010 04:48 PM
by Eduardo
|
1 |
105 |
|
|
|
February 11th, 2010 03:59 PM
by Mike H
|
8 |
181 |
|
|
Calculate days help by
Kim K
I am needing to calculate dates. What I need to accomplish, is according to
a school calendar, which has weekends, holidays and other specified dates off...
|
|
2 |
110 |
|
|
|
|
2 |
158 |
|
|
Number of days by
HK[_2_]
I connection with some (simple) interest calculation (where interest rate is
fixed every 1st July and 1st January and where interest calculation is based
on...
|
February 11th, 2010 02:44 PM
by HK[_2_]
|
2 |
118 |
|
|
|
February 11th, 2010 01:12 PM
by Joe
|
3 |
104 |
|
|
Vlookup formula by
Vijay
Iam using vlookup formula and the ce;ll which has no value gives me #N/A. I
want 0 there.How can I do that.
Thanks
Vijay
|
|
3 |
107 |
|
|
Extracting elements of a string cell by
PK
I have various cells some of which hold an alpha-number field, some hold an
alpha-number-alpha-number field, some are blank. These range for example from...
( 1 2)
|
February 11th, 2010 11:58 AM
by PK
|
11 |
243 |
|
|
Comment Box by
pipinghotxx[_2_]
I have an existing spreadsheet (that i didnt set up) that when you click on a
cell it automatically comes up with what looks like a comment box but there
no...
|
|
1 |
94 |
|
|
Hightlight cells that contain special characters by
Gareth_Evans (InterCall EMEA)[_2_]
Hi there, I have a spreadsheet containing first & last names (columns A & B),
up to 10,000 rows and some of the names contain 'foreign' characters - such
as...
( 1 2)
|
February 11th, 2010 10:45 AM
by Stefi
|
12 |
186 |
|
|
|
February 11th, 2010 10:21 AM
by Polly
|
7 |
138 |
|
|
|
February 11th, 2010 10:04 AM
by Mike H
|
1 |
99 |
|
|
|
|
1 |
100 |
|
|
Excel formula help by
Pags10
I work for a temporary housing company and would like to create a calendar
where all i have to do is put the clients name and dates they are staying in
a...
|
February 11th, 2010 05:47 AM
by Ando
|
1 |
112 |
|
|
Data Validation Lists by
Sue
I have a question regarding the drop downs lists created using Data
Validation. Is there any way to make them so that when I type something new
into the box...
|
|
5 |
130 |
|
|
Empty Cell-conditional formatting by
smack
I have a column where I enter a date when a document arrives. If it is left
blank for more than 7 days I need an alert. I also have a start date in A1
to...
|
|
1 |
96 |
|
|
Sorting data field by
Bill C[_2_]
I would like to sort the data in a sheet that is 6-9 columns wide so as to
find the event(s) when 3 consecutive horizontal cells in a row have the same
info....
|
|
1 |
92 |
|
|
Calculate # of years by
JT
I need to be able to calculate the estimated age of a piece of equipment
beginning at it's construction date. For example:
Air Handler "A" was built in...
|
|
6 |
125 |
|
|
|
|
1 |
118 |
|
|
'Reverse' Concatenate by
msnyc07
By which I mean removing part of a string.
Basically I want do something like
If Column A Contains String X then Remove Character A from end of Column B
|
February 11th, 2010 01:36 AM
by FSt1
|
5 |
135 |