Sometimes users type something in Excel that isn't correct. Follow the simple steps in this Microsoft Excel tutorial and learn how to restrict what data can be entered onto a spreadsheet which will work for most versions of Excel in this Excel tutorial for beginners.
Here is the formula used in the video:
=ISNUMBER(SEARCH("Yes", B2))+ISNUMBER(SEARCH("No", B2))
=ISNUMBER(SEARCH("Yes", A1:C10))+ISNUMBER(SEARCH("No", A1:C10))
If you are interested in more information about Microsoft then I highly recommend the channel @Microsoft
#microsoftexceltutorial #exceltutorial #usemybox
Remember to subscribe to Usemybox for computer how to videos in Excel, Word, Powerpoint, Windows, internet browsers and more.
Subscribe for More IT & Software How To Videos:
https://youtube.com/usemybox?sub_conf...
Смотрите видео Use This Trick To Restrict Data Entry In Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь usemybox 22 Июнь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 599 раз и оно понравилось 3 людям.