Hello, I can use help with a formula.  I am trying to reach a whole number
result.  Example:  75 x 10% = 7.5 .. however I need the result to calculate
to the closest whole number, in this case 8.  Now I know I change the
formatting however I need to take the 8 and times it by a ...

I have tables that are subsets of a much larger table.  However, one of the
subset tables, main subset table, is a point of reference for all other
subsets.  For example, the larger table is located @ A1:D10.  The main subset
table has cell formulas that point to the data in A1, ...

I am trying to get a formula set up that will look at multiple colums, and
produce output in a particular column based on the checks made.  It's a
boolean thing; here's an example:
In column A, I have dates in the format mm/dd/yy, in column B, I have text

Wondering if there is a way to indicate the Number of Records in an excel
document in a particular area without using the filter option.  So what I
mean is - when you filter on a field for a piece of information down in the
bottom of your screen it will tell you found 2 0f 2 ...

I would like to be able to look up a cell from Column A and come up with a
response in Colum B many to one and one to many relationships
i.e.
Apples    Granny Smith

Is it possible to use the named "nested If's", in the conditional format ?

The formula =COUNT(Sheet2:Sheet6!A1) works fine,
as does the formula =COUNTIF(A1:A6,"<4")
but the formula =COUNTIF(Sheet2:Sheet6!A1,"<4") does not.  If there anyway
of counting across sheets only when a particular condition applys?

I need excel to do something to whatever digit is filled out in a cell.
Like if I would fill out 3 in A1, A2 would spit out: 6 because (3+2+1=6)
This is particularly used in the sum of the years method. However I don't
need that function, I just need A2 to spit out what I mentioned ...

Can anybody tell me other limitations of formula that can be absorbed in a
conditional format window wherein a cell change color based on logical
conditions (e.g. 7 "IF"s,), search functions like lookups, etc....please give
awareness...

picture 10 hotels with identical pages for budget/actual line items (maybe
even a 12-month spread to a 13th total column.
anyhow, corporate has a 'master' spreadsheet with individual pages for each
of the 10 hotels, and a summary for the corp on page 11.

I want to use the Find and Replace function to find all the digits 5, 8 and 3
in my spreadsheet using the function once.

I know how to use IF statements to have do calculations or insert text or
numbers based on whether the IF statement is true or not.  Is it possible to
construct an IF statement that would physically change the spreadsheet?  For
example, IF <something is true> insert a row?  Or do ...

Hi, im working on Excel Workbook for soccer statistics. I have a litle
problem. I created a sheet on which I'll show statistics and games for
a selected club. A problem is with games for that club. I want to make
a table in which I'll show games for selected club. How to do that?

I changed one of the colors on the Tools / Options / Color Tab / Standard
Colors.  I want to make it permanent but when I exited excel and then the
next time I opened excel the color was changed back.  How do I make it
permanent?

I have a Named Formula:
=OFFSET(Htestc!BINFilStart,0,0,COUNTA(BINFilStart:A133),1)
once the formula is entered as a name the it changes to:
=OFFSET(Htestc!BINFilStart,0,0,COUNTA(Htestc!BINFilStart:Htestc!IV132),1)