The formula below will produce a value that is greater than 6 in my
spreadsheet.  However, I want to add another condition to this formula to
minus .5 ofF the value anytime the formula produce a value greater than 6.
Is this possible?

i have an excel shared file and i created some links to open PDF file.the
other users open the links exept one user. when he clicks on the links
nothing happens even no error messages.
Pls help

I have a set of survey data in Excel format. Some questions are in the format
of "check all that apply" and the answers i have are in a single column of
cells with each answer seperated by a coma. The answer could also be "other".
For some reason, the survey doesn't mark the ...

I have wrote a msgbox with vbYesNo. But encounter the problem of how to exit
this macro if end user click No on my msgbox. Please advice me on what should
i substitute 'DoNothing' in my macro below. Thanks.
If Response = vbYes Then    ' User chose Yes.

I have Sheet1 and Sheet2.  In Sheet1, Column A, I merged rows 1-4 as one cell
to contain the ID # for the person Column B: name in Column B1, address in
B2, city in Column B3, and phone # in Column B4.  When I entered the ID# in
Column A of merged rows 1-4 in Sheet2, I need the ...

I know that there is a limit to 3 conditions, however I was wondering of
there was a way to write a formula for the following:
I have a schedule for classes grades 1,3,&5. Each grade has 4 classes,
A,B,C,D, so a total of 12 classes.

I have a 2 MB excel file that used to open quite quickly. However, since I
added 2 worksheets the opening duration suddenly lasts over 3 minutes. I
don't think I did anything crazy and most surely not anything I had not done
before, but am afraid at one point this model will not ...

I have another question for this paper that I'm working on and I can't seem
to find the answer to. I'm a new user for Excel and I know next to nothing
about it. Any help you can give me would be great...
The question is: "If you see a spreadsheet with row AND column headings as

I need to see if anyone can tell me if it's possible to find the last
cell in a range that has a result and not just a formulas. We have this
file that has a row of formulas as each cell it a different day of the
month. In another file I need to pull the current cell and at this ...

when i right click on a cell to create hyperlink it doesn't appear.
pls help

Hello everybodcreated a folder "Office" in Excel (Excel 2002 SP2 / Windows
XP SP2/ German) beneath favorites to store local and network files to have
faster access to often used files in Excel.
After a couple of month (don't know what was installed between) I tried to

I have the following in cell C4 in sheet2:
="text 1 "&Sheet1!b3&" another text 2"
The cell C4 has three parts and can have ONE format for the font.
Is there a way to have the part taken from Sheet1 cell B3 to have different

see subject

Help I have a macro that runs multiple formulas.  However, when the formulas
are
finished I am left with about 64000 blank lines.  I am unable to insert a
row on the

Is there any 3rd party tool.  or microsoft tool that can export and import
the classes and modules in excel.
All at once.  In excel they limit to 1 class at a time.  to import or
export.