Previous Topic Next Topic

Excel

Closed
bobbymullick - May 12, 2010 at 08:42 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 09:32 PM
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

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 12, 2010 at 09:32 PM
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)
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses