Dissabling Error when editing formula with Find+Replace
 

A little background first. I have this formula

=IF(OR(Area!A4="Chainage", Area!A5="Base Area:", Area!A5="Total Area:",
Area!A5=""), "", ((Area!B5+Area!B4)/2)*(Area!A5-Area!A4))

Fairly simple. I have dragged it down across two thousand rows so that all
the row refernences update automatically. Now I wish to make the references
(truely) absolute using the INDIRECT formula as the table it refers to will
have rows inserted into the middle of it as it expands and contracts.

I know this can be done using the Find&Replace tool as I have done it before
on a similar table.

What I have forgotten is how to temporarilly disable the "The formula you
have typed contains an error" message, since I cannot insert all the required
parenthesis at once.

Dissabling Error when editing formula with Find+Replace
 

Hi

Put a single quote sign before the equal sign to treat the formula as text,
then edit your formula and remove it again when you are done.

Hope this helps.
....
Per

"ATChurch" skrev i meddelelsen
...
A little background first. I have this formula

=IF(OR(Area!A4="Chainage", Area!A5="Base Area:", Area!A5="Total Area:",
Area!A5=""), "", ((Area!B5+Area!B4)/2)*(Area!A5-Area!A4))

Fairly simple. I have dragged it down across two thousand rows so that all
the row refernences update automatically. Now I wish to make the
references
(truely) absolute using the INDIRECT formula as the table it refers to
will
have rows inserted into the middle of it as it expands and contracts.

I know this can be done using the Find&Replace tool as I have done it
before
on a similar table.

What I have forgotten is how to temporarilly disable the "The formula you
have typed contains an error" message, since I cannot insert all the
required
parenthesis at once.

Dissabling Error when editing formula with Find+Replace
 

Thankyou. I knew it was a simple answer. I blame the tie for cutting off
circulation to my brain.

"Per Jessen" wrote:

Hi

Put a single quote sign before the equal sign to treat the formula as text,
then edit your formula and remove it again when you are done.

Hope this helps.
....
Per

"ATChurch" skrev i meddelelsen
...
A little background first. I have this formula

=IF(OR(Area!A4="Chainage", Area!A5="Base Area:", Area!A5="Total Area:",
Area!A5=""), "", ((Area!B5+Area!B4)/2)*(Area!A5-Area!A4))

Fairly simple. I have dragged it down across two thousand rows so that all
the row refernences update automatically. Now I wish to make the
references
(truely) absolute using the INDIRECT formula as the table it refers to
will
have rows inserted into the middle of it as it expands and contracts.

I know this can be done using the Find&Replace tool as I have done it
before
on a similar table.

What I have forgotten is how to temporarilly disable the "The formula you
have typed contains an error" message, since I cannot insert all the
required
parenthesis at once.