Dissabling Error when editing formula with Find+Replace

  • Thread starter Thread starter ATChurch
  • Start date Start date
A

ATChurch

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.
 
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
 
Thankyou. I knew it was a simple answer. I blame the tie for cutting off
circulation to my brain.
 
Back
Top