Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a large set of sheets that need lots of data entered into multiple
colums. Each value that is entered into each cell needs to be modified by the following formulat ((INPUT*0.375)*1.334), where INPUT is the cell the data is entered into. Obviously the problem is a circular reference but the other problem is the overwriting of the formula itself when the INPUT is typed into the cell. Is there a way to: 1. keep a formula from being overwritten when a value is typed into a cell containing the formula? 2. (Tied to #1) Enter a value into a cell and have it modified or processed by a funtion in that cell which then displays the result in that cell? I've searched and read and nothing has yet provided me a solution. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Circular Reference quits | Excel Discussion (Misc queries) | |||
Circular Reference Problem Calculating Net Pay | Excel Worksheet Functions | |||
Circular reference help please! | Excel Discussion (Misc queries) | |||
circular reference (Excel 2000) | Excel Worksheet Functions | |||
circular reference when using a UDF | Excel Worksheet Functions |