Thread: Change Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fak119 fak119 is offline
external usenet poster
 
Posts: 21
Default Change Formula

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)

Is there an easy way to change these formulae faster then individually
change each cell?