Previous Topic Next Topic

Excel

Closed
bobbymullick - 12 May 2010 à 20:42
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 12 May 2010 à 21:32
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 May 2010 à 21:32
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)

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