Question about Microsoft Office Standard for PC
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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Aug 05, 2014 | Computers & Internet
Jul 30, 2014 | Xerox WorkCentre 7328 Multifunction laser...
Nov 01, 2013 | Televison & Video
Sep 17, 2011 | 2000 GMC Jimmy
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
Oct 06, 2008 | Toshiba Lands Phones
43 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: