I want to force the sheet user to enter only a "0" or a "5" in a cell and have it show only one of those numbers. I had used the formula =IF(cell>=5, 5,0) but cannot have the formula reside in the cell and show the result there. Any suggestions?
Select the cell(s), then click Data -> Validation. On the settings Tab, in Allow box choose List. In the Source box enter 0, 5. This will only allow these 2 numbers to be entered into the selected cell(s). There are many other validation combinations you can explore, this is the quickest way I found. Hope this helps.
Posted on Sep 11, 2007
Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!
Posted on Jan 02, 2017
Aug 05, 2014 | Computers & Internet
Jul 30, 2014 | Xerox WorkCentre 7328 Multifunction laser...
Nov 01, 2013 | Televison & Video
May 30, 2010 | Motorola Mobility RAZR V3
May 28, 2010 | Brother MFC 7840W Printer
Nov 05, 2009 | Microsoft Office Excel 2003 for PC
Aug 18, 2009 | Crosley CR248 Turntable
Feb 11, 2009 | Microsoft Excel for PC
Jun 23, 2008 | HP Pavilion a1410n (ER890AA) PC Desktop
Aug 20, 2013 | Microsoft Office Standard for PC
41 people viewed this question
Usually answered in minutes!
×