Find / Replace simple problem

[futureancient]

I have a column of formulae that contain a function. I want to insert an IF and a ROUND around them, but am unable to do this via adding it to the first cell then dragging, due to the cell references not necessarily being in order.

Put simply, I have to use find/replace to put the IF in, but I'm unfamiliar with how to abbreviate things in the find/replace menu.

What I'm trying to do -

Cell B36 currently reads -

=SimpleFunction(D17,D18,constantA,constantB)

I would like it to read -

=IF(I$9="None","",ROUND(SimpleFunction(D17,D18,constantA,constantB),4))

Please note that the cell references change out of sequence in the function, so where B36 references D17 and D18, B37 might reference D20 and D21. So what I need is a way to abbreviate the stuff contained within the brackets.

Can anyone help me out ?

 

[futureancient]

Anyone able to assist me ?

 

[jmthompson]

Does this work?
Find =, Replace with =IF(I$9="None","",ROUND(
Find ), Replace with ),4))

 

[futureancient]

Hi Jim,

I get as far as doing the first replace, but then an error message pops up telling me my formula is missing a parenthesis.

Essentially, my problem seems to be how to do the replace in one go, so that no error messages pop up between putting the front and back end of the formula in place.

Unless I've missed a way to do dual find replace's ?

 

[jmthompson]

Try switching to Manual calculation first?

 

[futureancient]

Nope, still not working, same error as before..

 

[jmthompson]

got it!

Find = Replace with " " (space)

Find ) Replace with ),4))

Find " " (space) Replace with =IF(I$9="None","",ROUND(

 

[futureancient]

Thanks JM !

One last thing.. I've now been left with a few hundred cells showing me the formula rather than the result. I have the cells formated as Number, but all I have is text... how do I get these formulas to work? Apologies for the terribly novice questions!

 

[jmthompson]

Try find = replace =