Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / January 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
IF Formula Determination22 Jan 2004 21:03 GMT4
I have 4 columns / cells:
A1 = current price
B2 = low price
C3 = high price
trying with out quotes... If-Then problem22 Jan 2004 21:01 GMT1
Sorry,
this is a repost from about ten minutes ago. I made the
mistake of using quotes. Lets try again.
I sell items on ebay. I have learned how to create a few
Excel Reverse Address type of problem22 Jan 2004 20:57 GMT1
I'm trying to figure out a way that I can search portion of a worksheet
for a value and have the result be the address of that cell.  It seems
that Excel will only search an address and display it's value.
ANYONE???:confused:
Two Instances of Workbook22 Jan 2004 20:49 GMT2
I am running Excel 2000 on XP Pro.
When I open a workbook, it opens two instances of this
workbook. Can someone please tell me how to not do this?
This only happens with one workbook. Others are OK. So I
Vlookup returns #N/A#22 Jan 2004 20:40 GMT3
I exported a table from Access to Excel.  When I do a
vlookup on the table, I get the #NA#.  If I retype the
index column's cell entry in the lookup table, the result
of the formula changes to the correct result.  I have
Worksheet name equal cell value22 Jan 2004 20:20 GMT3
I am looking for a way to have worksheets automatically
renamed to the value entered in cell A1, either
individually or all together (for all worksheets in the
workbook).  Need this in a hurry if anyone has a
Zip + Four Question22 Jan 2004 19:47 GMT1
I have a spreadsheet being used to merge addresses into letters and labels.  The column containing the zip codes are all either five-digit or five-digit+four with no dashes to separate the five and four digits.  Can someone please tell me how to insert this command into the ...
Remove link!22 Jan 2004 19:41 GMT2
Is there a way to remove links (VBA or otherwise)? I know
that my spreadsheet is no longer linked to another
worksheet but when you click link, the "Source File" still
bears the name of the previous source. How can I delete
more 1-2-3 converting22 Jan 2004 19:25 GMT1
I tried to make this one into Excel
@IF(@ISEMPTY(AT24)#AND#@ISEMPTY(AX24);"";@IF(@ISEMPTY
(AT24);@DAYS(AX24;@TODAY);@DAYS(AX24;AT24)))
whereas 2003-10-14 is the content of AV column..
Round Function22 Jan 2004 19:08 GMT2
How can I change .93 to .95 or 2.97 or 3.00. I have a list
of 1000 entries like this..
Can somebody Help.
i want to generate hands of poker...22 Jan 2004 18:28 GMT10
I want to generate dealt cards like in poker...
I created a list 52 numbers long...next to which i put 1s
2s 3s etc....
I have in my mind how this could work just using "if"
APR annual percentage rate formula/function22 Jan 2004 18:21 GMT2
Is there a function, or perhaps you know a formula that
will calc an APR for my home loan which includes fees.
I dont want a canned internet calculator, i'd like the
formula and/or function.
Look up values22 Jan 2004 18:11 GMT3
I am trying to write a formula to look up values in column
B depending on two values in column A.
E.g.
Col A
special function22 Jan 2004 17:38 GMT1
I am looking for a function similar to
"if(condition; calculate something; retain current value)".
This means, the value in the cell shall only be recalculated, if the
condition is met, else the current value is kept.
Excel Lists22 Jan 2004 17:30 GMT9
Want to create a drop-down list from a data range in
another Excel workbook.  When I try this the Validation
menu gives me an error that says it cannot use data from
another workbook or even another worksheet.  How can I
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.