Question about Microsoft Office Standard for PC

1 Answer

Forced cell entry

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?

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 27 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

I had Windows 8.1 istalled in my Pc but it showed problem now i want to install windows 7. I have windows 7 bootable USB and want clean instalation. i booted from USB and opened stup and formatted my


Simply formatting the hard drive does not remove all residual traces of the previous installation. When you get to the step for formatting, go to the advanced button and delete the partition that contained windows 8. Then create a new partition in the space, format, and install windows 7.

Aug 05, 2014 | Computers & Internet

1 Answer

Xerox 7328 diagnostic entry procedure


To enter the CE mode:
  1. Press and hold the 0 key for 5 seconds, then while still holding down the 0 key, press the Start button. The CE Access Number screen will appear.
  2. Enter 6789 and press Confirm.
  3. The top most area of the UI display will be reversed to let the user know that the mode has changed to the CE mode.

Jul 30, 2014 | Xerox WorkCentre 7328 Multifunction laser...

1 Answer

Write a program that creates a linked list of characters from a string entered by the user. (The string can be initially entered into an array if you wish.) Your program is then to move the second part...


Here's a brute-force C++ program to do it, assuming FixYa doesn't mangle the formatting. The last loop merely outputs the resulting list, since it makes no sense to just do all the work without showing the result.

====================
#include <iomanip>
#include <iostream>
#include <list>
#include <string>
using namespace std;
int main()
{
int brk, j;
list<char> lst;
string str;
cin >> str;
for (string::const_iterator i(str.begin()); i != str.end(); ++i)
lst.push_back(*i);
cin >> brk;
j = 0;
for (list<char>::iterator i(lst.begin()); j < brk; ++j) {
lst.push_back(*i);
lst.erase(lst.begin(), ++i);
}
for (list<char>::const_iterator i(lst.begin()); i != lst.end(); ++i)
cout << *i;
cout << endl;
return 0;
}
====================

Nov 01, 2013 | Televison & Video

1 Answer

I have a Motorazr V3M. It keeps assigning speed


all cell phone do this, but you can force the speed dial to #2 thru #9...
(for example to find who is in speed dial position number 49 press 49# on cell)

May 30, 2010 | Motorola Mobility RAZR V3

2 Answers

How do I enter the number "0" when entering a password for WLAN? I'm trying to connect to a WLAN using WPA encryption with a password including the number "0" but when pressing "0" it shows up as a star...


Brother's documentation is non-intuitive. Pressing the ' 0 ' key shows a ' * ', but it actually is accepted as a 0 and moves to the next character entry position. Just take it on faith that it enters a 0 when it shows * when entering the wireless key.

May 28, 2010 | Brother MFC 7840W Printer

2 Answers

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...


Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

My brandnew Songwriter is not playing records properly. When a quarter is placed on the tone arm, it plays fine. Is there an adjustment I can make??? Marilyn


http://www.crosleyradio.com/Manuals/CR248_Manual.pdf
I didn't see the tone arm balance adjustment in the user manual, however that is what needs to be done. At the rear of item #39, on page 10, is there a dial with numbers from 0 to 4 or 5? If so, set the dial to "0" to see if the tone arm will "balance" (like a see saw) If not, the dial assembly (which is a weight) needs to be slid either forward or backwards to achieve balance. After balancing, turn the dial to a number higher than 0 to increase tracking force..keep increasing the tracking force until it stops skipping, but no more than necessairy. To much force causes wear/damage to albums. If there is no tracking force adjustment on the tone arm, I would suggest contacting Crosley @ http://www.crosleyradio.com/Support.aspx
Hope this helps.

Aug 18, 2009 | Crosley CR248 Turntable

4 Answers

How to use vlookup in openoffice using different sheets


=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

2 Answers

SEcured web sites not opening


plz scan for viruse an use mozilla firefox it if free,more secure and fast

Jun 23, 2008 | HP Pavilion a1410n (ER890AA) PC Desktop

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

41 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...