|
|
excel formula by
Clinton Spry
I need to know how to put in a formula that will let me calculate something
like this.
0 to 5 miles $0
next 25 miles is $2.15 each
next 30 miles is 2.25...
|
April 5th, 2010 01:10 PM
by Eduardo
|
3 |
140 |
|
|
restrict view of certain cells in excel by
Firemann25
I am trying to restrict access to some users in excel. I am trying to make
it so those that do not have the password can view the sheet "read only" but...
|
|
2 |
225 |
|
|
Time calc formula please. by
Mario[_9_]
Can you please tell me what the formula for this is please.
A1 (start time) 0800
A2 (end time) 1515
A5 (total hrs=) 7.25
I need the formula for A5
TIA
|
April 5th, 2010 12:34 PM
by Mike H
|
4 |
139 |
|
|
rks Data Validation by
RKS
Hi
I am entered 4 digit number in cell A2. i wnts when i entered number in cell
a2 its asked the number which catageory like abc, if a then show number*, if...
|
|
1 |
194 |
|
|
Fals Result in IF Formula by
Khalid A. Al-Otaibi
Hello,
Thank you all of helping us in Genral, you haelped me so many times.
Start End Exp....
|
April 5th, 2010 10:35 AM
by Mike H
|
1 |
116 |
|
|
percentage in excel by
donnah1234
hi i'm new to excel.
i need to know have to do a formula for percentage.
example:
total sales £22.50
i need to subtract 3.9% from total sales
any help...
|
|
2 |
131 |
|
|
Calculate How the Number of Specific word. by
Khalid A. Al-Otaibi
Valid
Expired
Valid
Valid
Expired
Is there any way of how can I calculate the number of a word in a column?.
For Example I want to Calculate How many in...
|
|
1 |
161 |
|
|
Dropdown List That Accepts Other User Input by
GEdwards
I cannot find if there is a way to have a dropdown list that contains
pre-defined data validation entries and also allow a user to input their own.
Is there...
|
April 5th, 2010 05:45 AM
by JB
|
5 |
165 |
|
|
help on a vlookup please by
Ditchy
Hi there
i need some help on a vlookup, I just can't seem to get it to work.
in sheet 1, B2 I have a name joe blow
in sheet 1, A2 I would like their street...
|
April 5th, 2010 05:34 AM
by Ditchy
|
5 |
135 |
|
|
alignment in a validation list by
Tonso
is there a convenient way in xl2003 to line items up left aligned and
right aligned in a drop down list.
example
red roses 1
white roses ...
|
|
3 |
161 |
|
|
Workbook_Open code help by
Colin Hayes
HI
I'm trying to put code in the open workbook area so that sheet1 and
sheet2 both open with the cursor on A200.
I'm getting errors with this code...
|
|
1 |
139 |
|
|
Paste Value Error by
[email protected]
I have a simple formula which evaluates to 4.3. If I copy the formula and
paste as value, the value I get is "4.29999999999995".
For example:
Finding the...
|
|
0 |
102 |
|
|
Delete entire row if older then 365 days by
Pas
How do I create a macro that will delete entire row if older then 365 days.
Dates are on col "A"
last col of data = "U"
Data is kept in sheet "details"
Thank...
|
April 4th, 2010 10:13 PM
by Pas
|
2 |
165 |
|
|
Autosize cells as data is entered by
Carol
Hello.
I have my cells set to Wrap & the row is set to Auto-Fit. The "Number" is
set to General.
When I add text, it wraps, however, the cell-size is...
( 1 2)
|
|
16 |
219 |
|
|
|
|
10 |
395 |
|
|
what if formula by
bob245
Thanks for your recent post for my excel problem. (Does anybody know how to
move set of cells so the lowest number plus info in
cells to the right can be to...
|
April 4th, 2010 05:55 PM
by JLatham
|
4 |
133 |
|
|
|
|
5 |
159 |
|
|
right click by
Steve davis
can u disable the right click button in excel
|
|
6 |
137 |
|
|
How to enter excel dates for last year? by
JCarlosJr
Hi gang,
Its tax time and I'm trying to enter my expenses ito EXCEL for last year
(don't even remind me I should do this as the year progresses).
Anyway,...
( 1 2)
|
|
10 |
216 |
|
|
Chart Goal Lines by
Office User
How do I add a goal line on my charts using Office 2007?
|
|
1 |
139 |