View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nate Nate is offline
external usenet poster
 
Posts: 79
Default Edit formula over a range

I have a formula that extends over a large range.
A1 A2
=ROUND(forecast!X3*$Q8,0) =ROUND(forecast!Y3*$Q8,0)

How do I modify the entire range so that it no longer rounds without
completely running a new formula.

Thank ou


--
Nate