Data validation in 3 cells
Hi all, I have 3 cells in sheet1 qty to sell 100 qty adjusted 15 current qty 105 if user puts in the qty adjusted 15 items will give qty to sell 11 which is over 105 items in current qty should stop the trade or give warning message . If qty to sell is less than or equal current qty 105 items , that i correct. How to do data validation on qty to sell not go over current qty ? Thanks in advance -- mtlp ----------------------------------------------------------------------- mtlpp's Profile: http://www.excelforum.com/member.php...fo&userid=2334 View this thread: http://www.excelforum.com/showthread.php?threadid=38763 |
Data validation in 3 cells
you can use the standard data validation possibility: because you may enter a formula into the maximum value = A1+A2 for example |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com