Ho Rhonda,

What is it that you are trying to do? If you have the user inputing a value
into the cell that that will overwrite the formula. Depending on what you
are doing there may be other ways of doing it.

Give enough detail of your spreadsheet for us to be able to understand what
you are doing but remember that we cannot see your shreadsheet.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rhonda" wrote in message
...
so it's not possible?

"Sandy Mann" wrote:

Rhonda,

but now the other problem that I need is if the cell (e9) above my cell
(e10)
should this be =IF(e10<=e9)THEN"0" or bracket use

If a formula refers to the cell that is holding the formula you will get
a
Circukar Reference Error

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rhonda" wrote in message
...
I haven't used in forever and now need... I have cells formatted
custome
as
0;-0;;@ so that if there is a 0 it won't show and become visually in
the
way,
but now the other problem that I need is if the cell (e9) above my cell
(e10)
is equal to or lesser than the formula should put a 0 in the cell and
therefore nothing will show.

should this be =IF(e10<=e9)THEN"0" or bracket use...really need the
help.