The following cells on my spread sheet produce the #DIV/0! error under the
following circumstances, and I'd prefer the cells to remain "blank" until
data is input to produce the outcomes identified (which do work once data is
provided):

I need to make a conditional formula based ont he below info
If A=75 then the column B must show 5%
If A >90 & <=99 then column B must show 7%
If A = 100 then Column B must show 8%

I just can't seem to get the syntax to work... Especially when I try to put
the path in a cell (A1). Plus I need to make the formula even more dynamic by
defining 5 variables as indicated below:
CELL A1 Path = \\NetworkServer\Mainfolder\DataFolder\Working CELL A1 Folder\

I'm having troubles to simulate the alt+enter character into a formula of
excel 2003.
In previous versions, I could use something like
= "A" & char(10) & "B"

I need to make a sheet with test questions and answers.  Then I need to put
in all students and their answers.  Afterwards I need it to caluate the
percentage that was correct.  Can anyone help?

Thanks in advance for any help or direction on this!
Is it possible to have the true and false results of an IF formula returning
clip art pictures opposed to text?
Many thanks

I have been using Excel for years and am runing 2003.
I have a file with 4 worksheets.
The first (1) worksheet is where I imput some data into various cells.
The second (2) is a Company Report whis is specifiec to only some of the

I have a list of (12) values that can go up or down on a daily basis.  The
problem I have is that I need to assign a point value to see where each value
falls compared to the other values?  Very Confusing I know, here is a short
example of whay I am trying to say:

I've just been speaking to our IT helpdesk and they said my request was too
hard and would take 5 hours to work out. I'm not so sure so I'll run it past
this group.
We have to acknowledge complaints within 2 working days from receipt.

i have 2 worksheets in one excel file
------------------------------------------------------------------------------------------
sheet1:
Currency ---------------Amount

I know that I am exceeding my nesting levels. But can anyone provide a fomula
that would help me make all 12 months work? Here is the first 6 months
formula that I have:
=IF(MONTH(B4)=1,'Jan Draws'!G4,IF(MONTH(B4)=2,'Feb

I have an EXCEL file which consists of two worksheets (1 & 2).
Data input into WS1 is transferred (by means of macro) and transposed in WS 2.
e.g.  Sheet 1 entries
              D                      E

does anyone no how to answer a proposed question like this. I was
looking through some old papers for next years module in this. As im
doing this as a module on my course and I want to get a head start in
understanding how to write this in essay formats.

Hi I am have having problem applying bold format within string text.  I
want to bold the Input!10 data pulled from another sheet.  is there a
way to do this?  is it even possible?
="your application will be renewing on"&" "&TEXT(Input!B10, "mmmm dd,

I have a simple product formula J19=H19*I19.  Every time I input new values
for H, the value for J does not change.  I have to double click J and hit
enter for the product to total.  This is happening on all of my excel docs
for all formulas.  Has anyone seen this before?