Control Sheet
I need to check that the values entered in a seperate sheet are entered
correctly within a certain range. If the entry is out of range, the user must get an error message that the entry is invalid. For instance: =IF(AND(A1=1;A1<=500);allow entry;disallow and prompt user because of invalid entry) What do I do? Best regards, Sonni |
Control Sheet
Select A1
<Data <Validation In the "Allow" drop down choose "Decimal" (or "Whole Number" if you just want integers) Enter 1 for Minimum, 500 for Maximum -- Regards, Dave "Cedrun" wrote: I need to check that the values entered in a seperate sheet are entered correctly within a certain range. If the entry is out of range, the user must get an error message that the entry is invalid. For instance: =IF(AND(A1=1;A1<=500);allow entry;disallow and prompt user because of invalid entry) What do I do? Best regards, Sonni |
Control Sheet
Hi!
The thing is that I want to maintain allowed values in one sheet, so Validation won't work. Any other ideas? BR, Sonni "David Billigmeier" wrote: Select A1 <Data <Validation In the "Allow" drop down choose "Decimal" (or "Whole Number" if you just want integers) Enter 1 for Minimum, 500 for Maximum -- Regards, Dave "Cedrun" wrote: I need to check that the values entered in a seperate sheet are entered correctly within a certain range. If the entry is out of range, the user must get an error message that the entry is invalid. For instance: =IF(AND(A1=1;A1<=500);allow entry;disallow and prompt user because of invalid entry) What do I do? Best regards, Sonni |
All times are GMT +1. The time now is 08:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com