While I am writing a formula, I move the cursor to a
cell that I want to reference in the formula. Usually,
目前分類:title (5957)
- Dec 25 Tue 2007 20:41
How to avoid name ref in formula?
- Dec 25 Tue 2007 20:41
help creating a formula using IF and AND
- Dec 25 Tue 2007 20:41
Formatting of dates into quarters
Hi folks,
- Dec 25 Tue 2007 20:41
How prevent email address from being hotlinked to open send msg wi
I have a spread sheet w/ a column of email addresses and every time I click a
cell w/ to change an email address, it opens the Outlook send email window.
- Dec 25 Tue 2007 20:41
Trying to truncate or separate the first 3 characters/digits of co
I have a spreadsheet with a column of numbers. I'm trying to extract /
truncate / remove the leading 3 digits in each cell. The numbers vary in
- Dec 25 Tue 2007 20:41
Excel and No Save
Hi
- Dec 25 Tue 2007 20:41
Files saved on CD automatically convert to Read-Only; why?
I am trying to save files to a R/W CD to be used repeatedly. I have verified
the files are not quot;read-onlyquot; before copying them, but they automatically
- Dec 25 Tue 2007 20:41
why can't i send my excel spreadsheet?
i can't send an excel spreadsheet, says it was sent, but isn't received. help?
- Dec 25 Tue 2007 20:41
How I insert cell in the baseboard?
How I insert cell in the baseboard?
- Dec 25 Tue 2007 20:41
reset information
would i be able to reset the information on my spreadsheet daily at a
particular time, even if i am not here? i am currently working on a board
- Dec 25 Tue 2007 20:41
Loop help
In columns F to AB I have various data, most of this data is in a Range format.
This information is calculated identically for rows 4 to 32, differing
- Dec 25 Tue 2007 20:41
Change link in pivot table
- Dec 25 Tue 2007 20:41
Using COPY with an IF formula
- Dec 25 Tue 2007 20:41
Hide Unhide Rows
I'm hidding multiple rows in 2 sheets. when i click format/rows/unhide on one
sheet it unhides all of them but on the other sheet it doesn't unhide any of
- Dec 25 Tue 2007 20:41
conditional formatting
aWhy cant you have more than 3 conditinal formats? Is there any way to add
more without going into this visual basic stuff?
- Dec 25 Tue 2007 20:41
How to change an excel sheet into a picture?
1. I get jibberish when I try to insert the excel spreadsheet into the word
document. The document originated as a template chart. I'm wondering if that
- Dec 25 Tue 2007 20:41
Need formula help setting a range for calculations
I made the following formula:
=IF(AND(F16gt;12,F16lt;25),(really large formula)/12*(F16-12),0)
- Dec 25 Tue 2007 20:41
help with formula
- Dec 25 Tue 2007 20:41
results on sheet 2
I have golf program I am working on. Here is the setup
- Dec 25 Tue 2007 20:41
How Do I Do an Exclude Filter based on a Named Range?
I have a 450 record listing that has five columns in it, of which, column C
is quot;Locationquot;. I also have a named range in Column J called