How could I put up a IF function with multi-conditions?
Y for "Meets", "Mostly Meet" and "Exceeds"
N for "Not Meet" and "unable to assess"
No Info for no content in cell

I'm currently using the formula below to calculate the number of subscribers,
at each subscription rate, on each delivery route. It works when the
subscriber receives a quantity of one, but not when the subscriber receives
more than one (see route2 s.total). Any assistance is ...

subject says it all.

I have a spreadsheet that I created and everything is just the way I want it,
but I want to be able to lock the date field so that it can not be change by
other people.  
Can anyone give me some advice on how to do this?  I tried the locking cell

I can get SUM, MAX and MIN functions to work in arrays with multiple criteria
like this:
{=MAX(Diameter*(Job=$A6)*(Date>=$A$1)*(Date<=$A$2))}
But, from the example above, I now need to use MODE instead of MAX to return

Hello and thank you for your help. Hopefully, I can explain what I am looking
for and it is a simple formula!
I have a drop down list in cell B3 (example: list is apple through zebra).
In cell O3, I would like a certain percentage show in the O3 cell when the

I want create formula, =IF A1<100*.8, IF A1<200*.6, IF A1 <300*.5.
And where is the less than/ equal sign at?

I'm trying to get the top ten ranking locations based on the sum of
the sales.  The real list is 1000s of entries so here is an example of
what it looks like:
Location #         Sales

I am having trouble with formula to round results to a multiple of 5
Current formula results return the following values and I want to round them
to the nearest  multiple of .05
Current    Desired

My first question, once I delete row 7 how do I get what was row 8 to turn
into row 7.  Should I worry about it because it may throw off my forumulas?  
My second main question is how do I get a reverse ranking for lack of better
term?  For example, basketball scoring high is good ...

I have a list of values in collum A and I wantto keep a running talle in
another colulm B is there an easyier way to do this than putting the sum
formular in each cell in collumI B I have 400 of these.
Example

Hi Again Experts:
I have a project with tremendous impact if I can determine if it is possible
to copy the first 10 lines of  the data in a Pivot Table from the
DropDown...Let me explain...

I've been given the task to figure out a per capita formula based on
information given to me.
I have the following columns:
-  Claims Paid

I have a spreadsheet with a wide assortment of data.  I have a period of
performance with start and end dates.  What I want to do is to take those
dates and have a formula that will spread the necessary data across a period
of time that matches the POP.

I need to be able to populate a form by selecting a Company Name.  I have a
template already created in which I am needing to populate approx. 15 cells
with information that is specific to the "Company".  These cells are "street
Address", "phone number", "1st product pricing", ...