Is it possible make a cell display the value of Zero if the the cell
value is zero or less or less than 1? Even better is it possible to
change the actual value using a formula under the same circumstances?
thanks

can i format a key to print a text string when pressed in excel

What function do I use to caculate someones age

I have a tracking sheet where I want to enter a formula to enter in cell
"done" if a range of cells from A3:A54 all have a value "done" or "NA" else
keep blank.
How do I do it?

I would like a flexible Formula to find the Maximum value for a specific
Month (criteria will vary)  and retrieve its corresponding Numeric Label from
Column "A".
Row1 Col "C" - "N" = Full Date formatted with Custom Month Format "mmm": Jan -

I have a worksheet Ive done and it says that the cells are protected and it's
prompting me for a password.  I've never protected it, and its on the computer
that I made the worksheet on.

I'm trying to give a word/text a numeric value. High = 3, Medium = 2 and Low
= 1 etc.
I thought this could be done with a lookup table? If anyone has any
information on how to do this I'd be most appreciative.

I need to run a simple Countif in excell but only count entries that are
highlighted. Can anyone help???

try again - i screwed up
I have my last answer, ty to the person who answered it.  Here is my
current question.
Again in groups of 6 rows in a column, numbered 1-6, i need to make a

I am trying to weight a series of results and the obtain an overall rank.
Here is an example...
locations   Result 1     Result 2    Result 3
location1   515            89%         4.5%

Hello - I've searched, but cannot find what I'm looking for...  I need to do
this:
In the cell A3 the formula should say
If A1 = "red" and if A2 = "blue" enter 10 in A3, or

WHEN I COPY A VLOOKUP FORMULA THE CELL RANGE IS AUTOMATICALLY ADJUSTED. IS
THERE A WAY TO USE VLOOKUP WITH AN ENTIRE WORKSHEET AS THE RANGE THAT I WANT
IT TO SEARCH AS OPPOSED TO REFERENCING A SERIES OF INDIVIDUAL CELLS?

I am struggling!
This statement will count the number of "W/M"s that are "XYZ":
{=SUM(IF(($F$8:$F$57="W/M")*($D$8:$D$57="XYZ"),1,0))}
But what I would really like to know is the number of "W/M"s that are "XYZ",

I have a lot of numbers in a column and I want Excel to return the 4th
smallest number so I'm using the formula small(range,4).  However, the small
function works in this way: if I have the numbers (1,1,2,2,3,4) the function
small(range,4) returns 2, but I want it to return 4 ...

I'm tracking stats for stores performances in various departments.  Each
criteria has been assigned a value and the Total row sums the total points
for each store.  I would like another area/page to show the top store for
each month.  I have entered a formula to have it show the ...