Condtions to prevent a formula being deleted

**khalid79m** · 10-03-2007, 11:15 AM

Please Login or Register  to view this content.

I have this code in a cell v1 but it can be over typed only if there isnt a 2 in r8.

is there anyway i can set the sheet so that if anybody does overtype it in error ie if there was a 2 in r8 but someone changed the 0 to 5, can the sheet function reset that or is there away to fix the result of a cell.

i hope you undestand.. help please

*ps is there a formula which I can put in a cell which will always remain in the cell even if something is typed in it.

ie. if cell r2 is 2 the v1 = 0 , if cell r2 is 1 or 3 then you can enter 1,2,3,4,5 only

**Mark@Work** · 10-03-2007, 01:12 PM

The best I can come up with is to use the data validation facilities as follows.
First set up 2 cells (for the sake of this posting I will assume R3 and R4)
Set R3 =IF(R2=2,0,1) | Set R4 =IF(R2=2,0,5)
Then open the data validation settings window:
Data>Validation... | Settings
Allow:
Whole Number
Data:
Between
Minimum:
R3
Maximum:
R4
This will set the minimum and maximum allowable numbers based on the value in R2 as required.
Mark.

**khalid79m** · 10-04-2007, 05:30 AM

In row E i have a list of names , sometimes this list of names is runs from e3 to e503 and sometimes the list only has one entry in which is e3

I have a formula in a3 which I want to fill down but only for the number on names in the E coloumn

so if theres 500 names the formula would fill down from e3 to e503
if theres only 20 names the formula would fill down from e3 to e23
and if theres only 1 name the formula would only work on e3 and not fill down.

can anyone help.. thanks

Condtions to prevent a formula being deleted

LinkBack

Thread Tools

Rate This Thread

Display

Condtions to prevent a formula being deleted

fill down query

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions