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 / August 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Customizing MSOffice 2K Format toolbar.24 Aug 2005 06:30 GMT2
I am trying to customise my format toolbar by adding sheet right to left  
/left to right button. When ever I drag these buttons from customize to
toolbar the buttons does not appear.Is there a bug in software as usual or
...!
Need a help with the IF/ IFCOUNT function24 Aug 2005 04:48 GMT4
I am designing a quote sheet where different markups will be placed
depending on different value.
As an example:
If a product is between 0 and 19.99 I want to mark it up 100%
Lookup - Pro-rate formula24 Aug 2005 04:18 GMT3
I am looking for a formula  to include in a spreadsheet for the following:
I have two equal length columns of no more than 50 numbers.
Say:
A        B
Newbe Help with count/countif function24 Aug 2005 03:48 GMT5
:confused: I'm trying to count the number of rows that fall within a
numerical range. For example I want to count the number of rows that
contain a value >5 and <=10
I tried both count and countif and keep getting errors. Half if it is
Number of paychecks in a month?24 Aug 2005 02:35 GMT15
In my spreadsheet, I have a column for each month, 8/1/05, 9/1/05
etc...
What I want to know is, how many paychecks will I receive each month?
I get paid every other week on a Friday.  
How do you format a cell for % varience for multiple answers24 Aug 2005 02:33 GMT1
                VARIENCE   
A        B        $    %
12.00         15.00         3.00     25.00
(12.00)        15.00            
Matching a sampling # to it's row #number24 Aug 2005 02:20 GMT3
here is my data:
col A      col B    col C        col D
store#    row                    sampling #
3             1                         210
create default cell value24 Aug 2005 01:18 GMT1
Is there a way to specify a cell to contain a default value?  
Vlookup then OFFSET over and down24 Aug 2005 00:33 GMT3
Okay
This is a much simplified version, but...
How do I write a function statement that will:
1) Do a vlookup to find a value
Product formula help23 Aug 2005 23:56 GMT2
I'm new here so I don't know if this kind of a question was here before ;)
Here's the problem: On a worksheet I have two columns with about 100 or even
more rows and in every filed there is a number (i.e. in A1 is typed for
example 100, in A22 is typed 65983, in B3 is typed 456.. ...
Payment formula Question23 Aug 2005 22:15 GMT1
My worksheet calculates payments with the first payment due in 30 days. How
would I modify the formula to allow me to calculate payments using any number
of days to first payment up to 45?
column to column conditional formatting won't work, need formula23 Aug 2005 22:07 GMT1
I have a user who has 3 columns.  She has a machine listed in the first
column, the result in the 2nd column and if that result is over equal or
greater than 200, she wants the machine name listed in the different column
column.  My confusion stems from the number of machines, ...
How to transfer info from PDF file to excel (lists)????????23 Aug 2005 21:54 GMT2
I would like to know how to take a document and scan it into a PDF file and
then transfer the list info from that file to an excel worksheet????
How do I calculate operating expense23 Aug 2005 21:44 GMT8
Signature

K.E.
  Tx.

IF statements/formula problem23 Aug 2005 21:35 GMT15
I need to tell column B if there there is something in column C greater
than zero then use column A figure.  Otherwise use A/2.
   A               B              C               D
 Savings     Shared     Flat fee    TOTAL
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 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.