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 |
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 |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com