ExcelBanter - condditional farmulation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - condditional farmulation (https://www.excelbanter.com/excel-worksheet-functions/264270-condditional-farmulation.html)

RAMAN

condditional farmulation

sir, i want to do in excel such type of farmla through we can not leave blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell

raman

condditional farmulation

your kind help required..

"RAMAN" wrote:

sir, i want to do in excel such type of farmla through we can not leave blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell

bala_vb

Quote:

Originally Posted by RAMAN (Post 955232)

sir, i want to do in excel such type of farmla through we can not leave blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell

can you elaborate more in brief? are you looking for any consecutive numbers, when user entered the value say 3?

Ashish Mathur[_2_]

condditional farmulation

Hi,

You may select the range where you want the user to enter the number and
then go to Data Validation Allow Whole Numbers and then specify the
range. Click on OK.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RAMAN" <RAMAN @discussions.microsoft.com wrote in message
...
sir, i want to do in excel such type of farmla through we can not leave
blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell

All times are GMT +1. The time now is 10:02 AM.