February 24, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Drop down for whole numbers and N/A?

I am looking to create a box that allows for whole numbers or N/A.

I can data validation, set to whole remove error message. But this means people can write anything in there.

The numbers are extremely varied so creating a list of numbers doesn’t woke.

I’m thinking maybe an if then statement maybe?

Check out the full article on the original site

#Excel alternatives for data analysis

#generative AI for data analysis

#natural language processing for spreadsheets

#rows.com

#big data management in spreadsheets

#conversational data analysis

#Excel compatibility

#real-time data collaboration

#intelligent data visualization

#data validation

#whole numbers

#N/A

#if then statement

#error message

#create a box

#list of numbers

#Excel

#varied numbers

#user input

#input method