Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,533
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace Formula Ruan Excel Discussion (Misc queries) 6 March 1st 07 07:34 AM
Find and replace numbers using a formula michelplantz Excel Worksheet Functions 6 November 6th 06 04:13 PM
Find Replace Formula shakey1181 Excel Discussion (Misc queries) 1 October 11th 06 02:15 PM
Find Replace Formula shakey1181 Excel Discussion (Misc queries) 0 October 11th 06 02:11 PM
Find and replace error meesh1224 Excel Worksheet Functions 1 February 2nd 05 03:52 AM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"