Functions

Using DCOUNT
I have two cells containing the DCOUNT function. In the first cell, I have set the criteria to "Post-Phase 3". In the second cell, I have set the criteria to "Post-Phase 3 and PDU". The DCOUNT function in the second cell is counting items that meet its own criteria as well as the criteria used in the first D... 26 Mar 2010 22:57

Toolbar question
I lost the ability in the toolbars to see the full function band. I.e somewhere where I can type in the forumula. Which toolbar or setting allows this to happen? Thanks ... 27 Mar 2010 08:14

IF or VLOOKUP
Trying to look at value in one cell(column), then see if a value in another cell in the same row equals a specific value, then return True or False ... 26 Mar 2010 13:12

How to carry Excel balance on 1 w/s to another?
I am looking to carry a balance on one worksheet to the next. I know that the $ is used but cannot find the format. ... 26 Mar 2010 12:01

hOW TO CREATE A BOOKMARK IN EXCEL+
... 26 Mar 2010 10:25

Using VLOOKUP to find colours
Hello, I want to use a VLOOKUP to pull information out of a chart depending on what colour the cell has been filled in. The Look_Up value needs to relate to the colour but i do not know how to force it to do this. Any help would be appreciated. ... 27 Mar 2010 10:52

Filter formula
Hi, I am looking for a formula that can act as a filter. In sheet AA I have a table with headings products, date, diameter etc starting from col A. I would like in sheet BB to be able just to see data corresponding to a certain product, call it Cars. The user enters Cars in B2 sheet BB and the formula f... 26 Mar 2010 22:57

Calculating percent of times a value is in a column and total #
Ok so I have a column with values in it. Say A4:A12, the values entered will always be 1, 2, 3, or 4. I need a formula that will calculate the % that say a 1 appears in that range and I need a formula that will calculate the total number of 1s in that range. Thanks! ... 26 Mar 2010 10:25

Round
I'm making price list. 150 articles and I want that every price have last number 9. Ex. 1651,00 = 1659,00 1255,00 = 1259,00 etc... Help! ... 26 Mar 2010 06:56

Updating Consecutive Cells in a Range
How can I update the next consecutive empty cell in a range each time a value is entered in the same cell? For eample, I enter bank account balances in cell c4. Each time the next consecutive empty cell in range c6:c20 updates with the value entered. Thanks for your help. ... 26 Mar 2010 03:36