Sir,
Is there any where formula wherein if, if condition is not met, the value in a particular cell should not be changed.
Sir,
Is there any where formula wherein if, if condition is not met, the value in a particular cell should not be changed.
Hello, durai
You should use "data validation". Select the cell you want to constraint the values and then go to Data>Data Validation in the dialog box chosse customize (I think that is the word in English) then you have to enter a formula which is going to limit the value of the cell.
I hope this help, or you can attach the file with more detail of the restriction over the cell value in order to help better.
As an example I attached a file. In yellow cell, I only can enter numbers that I find it in column E. Try it.
Regards
Basilio