| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
divide all cells in a spreadsheet by 1.5
i am trying to divide all cells in a spreadsheet by 1.5 but i keep getting an
error message about creating a circular reference. can someone help by giving me the correct formula to use. many thanks angela |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide all cells in a spreadsheet by 1.5
In a separate worksheet, enter 1.5 and copy this cell.
Go back to your original worksheet, select all the cells you want to modify and PasteSpecial/divide -- Gary''s Student - gsnu200748 "angela" wrote: i am trying to divide all cells in a spreadsheet by 1.5 but i keep getting an error message about creating a circular reference. can someone help by giving me the correct formula to use. many thanks angela |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To take the cells in the same row and divide them in rows | Excel Discussion (Misc queries) | |||
| How do I divide a cell into two cells? | Excel Discussion (Misc queries) | |||
| average 2 cells (Mileage Divide by Gallons in two cells | Excel Discussion (Misc queries) | |||
| how to add and divide certain cells? | Excel Discussion (Misc queries) | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Linear Mode
