| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit validation list range | Excel Discussion (Misc queries) | |||
| allow users to edit range | Excel Discussion (Misc queries) | |||
| How to edit a named range | Excel Discussion (Misc queries) | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| "Allow users to edit range." Office 03 vs. 97... | Excel Discussion (Misc queries) | |||
Threaded Mode
