Prevent Negative Numbers in a column

[manubhanot]

Greetings to all! I just joined this forum so that I can learn from the experts and contribute as much as I can.

I have a situation for which I am looking a solution for:

I have three sheets in my excel file to manage inventory, namely, Demand, Supply, Inventory. Let us say that an article in Cell A2 in "Demand" = 5 and the same cell in "Supply" = 7; so we should be ok (because we have more than what is being demanded). Cell C2 in Inventory will show +2 (7 minus 5) as 2 items will be left after delivering 5.

I would want some formula that will help me restrict negative entries. Let me explain: Let us say that an article in Cell A2 in "Demand" = 7 and the same cell in "Supply" = 5. This would mean that a negative numbers will appear in Cell C2 of "Inventory" sheet. (because we have less than what is being demanded). I would want to put some kind of validation so that I can prevent this from happening.

Thanks in advance.

 

[manubhanot]

If it's only Column F and Column R, I would enter it separately, just like the way you did Column F.

It is actually all the columns starting from F upto column R

 

[RoryA]

Change the formula to:

=F2<=INVENTORY!$D2

and apply the validation to all the columns. If you need the column D reference to adjust for each column too, remove the $ from that part too.

 

[manubhanot]

If it's only Column F and Column R, I would enter it separately, just like the way you did Column F.

Actually I would like the formula applied starting at column C all the way upto column R.