Great than or Equal To??

Trust1 · May 25th, 2002, 11:44 AM

I'm putting together an inventory control database and need to have 30/1 (one for each day of the month)columns which will only accept numbers equal to or less than the control column, which holds the exact number to items in inventory. What type of formula could I use to accomplish this. I'm rather new to Excel, but a fast and excited learner.

Brian from Maui · May 25th, 2002, 12:00 PM

Have a look at data validation

Go to Data/Validation/Allow

You could also include why the entry is not allowed under error alert.

Not sure if this is what you want, since you're asking for a formula

Or use custom and something like =b1<=a1, where a1 is the control cell

[ This Message was edited by: Brian from Maui on 2002-05-25 11:04 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 11:44 AM	#1
Trust1 New Member Join Date: May 2002 Location: Seattle Posts: 1	I'm putting together an inventory control database and need to have 30/1 (one for each day of the month)columns which will only accept numbers equal to or less than the control column, which holds the exact number to items in inventory. What type of formula could I use to accomplish this. I'm rather new to Excel, but a fast and excited learner.

May 25th, 2002, 12:00 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Have a look at data validation Go to Data/Validation/Allow You could also include why the entry is not allowed under error alert. Not sure if this is what you want, since you're asking for a formula Or use custom and something like =b1<=a1, where a1 is the control cell [ This Message was edited by: Brian from Maui on 2002-05-25 11:04 ]