Excel

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Example : I have column A' where i am entering a number and this number (given by the user) has to be multiplied by 10 and the value/answer should appear in column C. If a user is enter number 7 in column A, column C should automatically have the value of 70 but if any user is trying to enter 70 directly in column C, it should give a message or it should be protected or not allowing the user to enter any value directly in column C

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
To prevent user to enter any value in a cell, first you have to protect sheet and then apply lock. Lock is default for all cells, so make sure that you removed lock.

in that locked cell you can have this formula

=IF(A1="", "", A1 *10)