software

I have a cell that has a formula entered into it. At certain times in the
month of operations this cell with the formual needs to be replaced with a
meter reading. I have the worksheet protected expcept for this cell so people
can enter in the reading.ow is there another formual or way to tell when this
formula has been replaced with the reading, maybe in the form of another
formula in another cell.
Thanks in adavance
Scott

Hi Scott,

Why not use another cell to enter the reading?
And then your formula would be something like

=IF(A1=quot;quot;,YourOriginalFormula,A1)

--
Kind regards,

Niek Otten

quot;scottquot; gt; wrote in message
...
gt;I have a cell that has a formula entered into it. At certain times in the
gt; month of operations this cell with the formual needs to be replaced with a
gt; meter reading. I have the worksheet protected expcept for this cell so
gt; people
gt; can enter in the reading.ow is there another formual or way to tell when
gt; this
gt; formula has been replaced with the reading, maybe in the form of another
gt; formula in another cell.
gt; Thanks in adavance
gt; Scott
If your formula is just setting a default value, try something like this
example:

A1: =quot;100quot;
Note: A1 will contain the quot;wordquot; 10, but Excel can still treat it like a
number.

B1: =1*A1
(returns the number 100)

C1: =ISTEXT(A1)
--gt;returns TRUE if the default formula (or text) is in Cell A1
--gt;returns FALSE if a number is in Cell A1

Something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Proquot;scottquot; wrote:

gt; I have a cell that has a formula entered into it. At certain times in the
gt; month of operations this cell with the formual needs to be replaced with a
gt; meter reading. I have the worksheet protected expcept for this cell so people
gt; can enter in the reading.ow is there another formual or way to tell when this
gt; formula has been replaced with the reading, maybe in the form of another
gt; formula in another cell.
gt; Thanks in adavance
gt; Scott

Niek

I wanted to try and make this simple, maybe you have a suggestion. I
appreciate your suggestion but this is what happens. We have two different
chemical feeders. When we switch feeders on what ever day it is we need to
eneter in the meter readings. My ss is set up for entire month. So when the
meter reading is entered in it will carry over to the next day. Now on the
days that the feeder is changed I do not want the one reading to carry over,
now that that feeder would be taken out of service. I am looking for
something easy because of the number of people that is invloved. I would like
to just enter the reading (putting the feeder in or out of service) and not
have much confusion as to delete the old reading or not. Below is how I have
it now, remeber that the north feeder gets its reading from the day before if
it is in service. The south feeder is reset every day so I do not need to
carry that reading over. They both feed the same chemical but one is newer
and is reset every night.

North Feeder
cell b1-this is is blank to put the end of the days reading in
cell b2=if(b1, the day beforegt;0, b1,0)

South Feeder
c1-just eneter in reading because it is reset everyday.
The problem occurs when say we are using south feeder and then switch to
north feeder. We put in the reading on the south and then go to cell b2 and
eneter in the start up reading. Vice versa when we switch from north to
south. Hope you can get this.

Scott

quot;Niek Ottenquot; wrote:

gt; Hi Scott,
gt;
gt; Why not use another cell to enter the reading?
gt; And then your formula would be something like
gt;
gt; =IF(A1=quot;quot;,YourOriginalFormula,A1)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;scottquot; gt; wrote in message
gt; ...
gt; gt;I have a cell that has a formula entered into it. At certain times in the
gt; gt; month of operations this cell with the formual needs to be replaced with a
gt; gt; meter reading. I have the worksheet protected expcept for this cell so
gt; gt; people
gt; gt; can enter in the reading.ow is there another formual or way to tell when
gt; gt; this
gt; gt; formula has been replaced with the reading, maybe in the form of another
gt; gt; formula in another cell.
gt; gt; Thanks in adavance
gt; gt; Scott
gt;
gt;
gt;

Niek
I forgot to mention that b1-b2 is chemical used

quot;scottquot; wrote:

gt; Niek
gt;
gt; I wanted to try and make this simple, maybe you have a suggestion. I
gt; appreciate your suggestion but this is what happens. We have two different
gt; chemical feeders. When we switch feeders on what ever day it is we need to
gt; eneter in the meter readings. My ss is set up for entire month. So when the
gt; meter reading is entered in it will carry over to the next day. Now on the
gt; days that the feeder is changed I do not want the one reading to carry over,
gt; now that that feeder would be taken out of service. I am looking for
gt; something easy because of the number of people that is invloved. I would like
gt; to just enter the reading (putting the feeder in or out of service) and not
gt; have much confusion as to delete the old reading or not. Below is how I have
gt; it now, remeber that the north feeder gets its reading from the day before if
gt; it is in service. The south feeder is reset every day so I do not need to
gt; carry that reading over. They both feed the same chemical but one is newer
gt; and is reset every night.
gt;
gt; North Feeder
gt; cell b1-this is is blank to put the end of the days reading in
gt; cell b2=if(b1, the day beforegt;0, b1,0)
gt;
gt; South Feeder
gt; c1-just eneter in reading because it is reset everyday.
gt; The problem occurs when say we are using south feeder and then switch to
gt; north feeder. We put in the reading on the south and then go to cell b2 and
gt; eneter in the start up reading. Vice versa when we switch from north to
gt; south. Hope you can get this.
gt;
gt; Scott
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt; gt; Hi Scott,
gt; gt;
gt; gt; Why not use another cell to enter the reading?
gt; gt; And then your formula would be something like
gt; gt;
gt; gt; =IF(A1=quot;quot;,YourOriginalFormula,A1)
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;scottquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have a cell that has a formula entered into it. At certain times in the
gt; gt; gt; month of operations this cell with the formual needs to be replaced with a
gt; gt; gt; meter reading. I have the worksheet protected expcept for this cell so
gt; gt; gt; people
gt; gt; gt; can enter in the reading.ow is there another formual or way to tell when
gt; gt; gt; this
gt; gt; gt; formula has been replaced with the reading, maybe in the form of another
gt; gt; gt; formula in another cell.
gt; gt; gt; Thanks in adavance
gt; gt; gt; Scott
gt; gt;
gt; gt;
gt; gt;

It sounds as if knowing whether that cell has a formula is what you are
asking for. If you can use a UDF, the following seemed to work for me:

Function IsFormula(myRange As Range) As Boolean
If myRange.Range(quot;a1quot;).HasFormula Then IsFormula = True
End Function

and on the spreadsheet:

=isformula(C37)
returns either true or false
quot;scottquot; wrote:

gt; I have a cell that has a formula entered into it. At certain times in the
gt; month of operations this cell with the formual needs to be replaced with a
gt; meter reading. I have the worksheet protected expcept for this cell so people
gt; can enter in the reading.ow is there another formual or way to tell when this
gt; formula has been replaced with the reading, maybe in the form of another
gt; formula in another cell.
gt; Thanks in adavance
gt; Scott

Scott
The following Worksheet_Change event macro will do what you say you
want. As long as the formula stays in that cell (B1 as written now) the
macro will not fire when the dependent values change resulting in a change
in the value displayed in B1. But if a value is entered in that cell,
replacing the formula, the macro will fire. Post back if you need help with
setting up this macro with your data.
Note that this macro has to be placed in the sheet module for the sheet
that contains that cell. To do this, right-click on the tab of that sheet,
select View Code, and paste this macro into that module. Click on the quot;Xquot;
at the top right of the screen to return to your spreadsheet. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) lt;gt; quot;B1quot; Then Exit Sub
MsgBox quot;It changed.quot;
End Sub

quot;scottquot; gt; wrote in message
...
gt;I have a cell that has a formula entered into it. At certain times in the
gt; month of operations this cell with the formual needs to be replaced with a
gt; meter reading. I have the worksheet protected expcept for this cell so
gt; people
gt; can enter in the reading.ow is there another formual or way to tell when
gt; this
gt; formula has been replaced with the reading, maybe in the form of another
gt; formula in another cell.
gt; Thanks in adavance
gt; Scott