Change formulae easily?

F

fak119

I have to change a great amout of formulae from a simple

=A3/A4 to either

=ROUND(A3/A4,0) or

=IF(A4=0,"",A3/A4)

The cells are spread all over the sheet, sometimes in one row or line,
sometimes grouped together or sometimes individually placed anywhere on the
sheet.

Is there an easy way to change these formulae faster then individually
change each cell? Even changing each cell individually would be easier if
there was a way to wrap the old formula between the necessary alteration.

(PS: ASAP has a Macro that can alter the formula, but it can only add
something at the end and the formula is lost and the new value is shown.)
 
B

Bob Umlas

Why not Find/Replace?
Look in Formulas (not values) and Find A3/A4 and replace with ROUND(A3/A4,0)
or whatever
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top