Having problems with your PC Desktops ?

In excel what formula would you use to stop a cell changing after it has already changed for example using the formula =if(a2=a1,"win","")is ok but i require it that if a1 changes that the cell the formula is in doesn't change back to a black cell but remains showing "win"


Answers :

Hi,
A1 and A2 are reference cells and you will write this formula other then A1 and A2
now you need if A1 is less then 1 or zero, result should be "win" right?
apply this.. =IF(A2<=A1,"win","")
Now if A1 is 0 and A2 is 0, result will be WIN
if A1 is 1 and A2 is 0, result is WIN
if A1 is 0 and A2 is 1, result would be Blank.
Is this you need?
You can change formula by =IF(A1>=A2,"win","")

hit "add a comment" button for query / more info.
Thanks.
Repair Help & Product Troubleshooting for PC Desktops

Tips for a great answer:

- Provide details, support with references or personal experience .
- If you need clarification, ask it in the comment box .
- It's 100% free, no registration required.

Suggested Questions/Answers :

In excel what formula would you use to stop a cell changing after it has already changed for example using the formula =if(a2=a1,"win","")is ok but i require it that if a1 changes that the cell the formula is in doesn't change back to a black cell but remains showing "win"


Hi,A1 and A2 are reference cells and you will write this formula other then A1 and A2now you need if A1 is less then 1 or zero, result should be "win" right? apply this.. =IF(A2<=A1,"win","")Now if A1 is 0 and A2 is ... PC Desktops

Purchased a new Dell Inspiron 6000 (9 cell) battery


Have a look in your power properties and see the settings.They may be set at when battery reaches 30% The computer shutsdown. You can change the settings to your own preferance. ... Dell Inspiron 6000 Notebook

My MS Excel vlookup function ASCII type table contains both upper case and lower case letters, characters like ( and % or *, and numbers. It seems to return the numerical equivalent of upper case letters only, not the lower case, and fails on numbers, returning #N/A. The upper case letters and most of the other characters work properly.


Correct a #N/A error\015\012\015\012\015\012Show All\015\012 ... PC Desktops

No internet connection - PC Desktops


Internet connection solutions\015\012\015\012Restart the computer. \015\012Test the jack. \015\012Test the equipment. \015\012\015\012Try a different jack that you know work ... PC Desktops

Wont boot up


Dear bebjirmav\015\012\015\012usually a machine that refuses/ gets gobby on boot up has either a config error or hardware fault. Now the first thing i tend to do is whip out that hard drive (carefully though as the thing is fairly fragile ... HP Pavilion dv6000z Notebook

Change text on Window start Button


Step 1 - Modify Explorer.exe File\015\012\015\012In order to make the changes, the file explorer.exe located at C:\\Windows needs to be edited. Since explorer.exe is a binary file it requires a special editor. For purposes of this article I hav ... PC Desktops

Laptop to tv


If your tv don't have s video input,you can get an Svideo to RCA cord.\015\012If the tv does have s video input,just get an s video cable and plug it into the tv and computer s video ports and follow the steps below for setup.\015\012 ... Toshiba Satellite L305D-S5895 Notebook

HP Compag 2510 (GM651AW) sn CZC752128G reset password Bios


Just go to hereEnter your model and hash code and they email back ... HP Compaq 2510p Notebook PC

I need to get rid of a virus. I don't seem to be able to get on to Maxpc


Let me make sure I understand what you mean by "maxpc". Are you talking about the product that promises to "unleash the power of your pc" via registry scrubbing, etc.? Everything I type from this point on will be assuming as much.First of ... PC Desktops

Raymarine E120, after 4h on display went dark in


Blubaju, probably cold-cathode-fluorescent-lamp backlight failure! if unit dosen't have electro-luminescent style backlighting. All LCD panels require WHITE light to see what is on the screen!!! Is same common problem that computer (pc) lcd monitors ... Raymarine M1500 15 in. Flat Panel LCD Monitor

Trying to use my hp laptop with sony lcd hdmi tv for movies


You should have an S video port on both tv and computer.\015\012\015\012If your tv don't have s video input,you can get an S video to RCA cord.If the tv does have s video input,just get an s video cable and plug it into the tv and c ... HP Pavilion dv6000z Notebook

Computer booting problem


Hi,\015\012\015\012You backup Lithium battery may require replacement. The CMOS/BIOS not remembering you prescribed setting is an indication that though the settings were saved, they were not retained and therefore when booted would display the "F1" ... Dell OptiPlex 270 PC Desktop

I CANT CHANGE THE REGION ON MY DVD, although I have 1 change left


Try using a software called DVD Shrink to watch your DVDs on. But check if its legal to use in your respective areas.\015\012You can see how many changes you have remaining by doing this."Right Click" on "My Computer" and select "Manage". ... Dell Inspiron 1300 Notebook

Usb flash disk not detected


There can be several reasons for Flash Drives not being detected \015\012by your computer. \015\012First your computer is not able to provide drivers for your Flash \015\012Drive. Now, for your information, you do not need to install any driver ... HP Compaq nx6110 Notebook

Monitor stays on for a few seconds then goes out


This problem is very often caused by dry electrolytic capacitors on the inverter board. If you have some skill with soldering you could try to change them. When buying new ones ask for LOW-ESR capacitors for switching mode power supplies (SMPS) and 1 ... Acer AL1711 17" Flat Panel LCD Monitor

Year old advent netbook 4211b will not turn on,


When you press power button press F1 or F2 or "del" key if you can see bios screen then you not need to refix RAM memory or reset bios.IF you can see bios screen then lake sure harddisk is detected and SATA is disable then save settings and exi ... Advent Netbook

Netgear Rangemax Router not supported/can't find wireless networks after first time it logged on.


Lets do it again...1. Check physical connections. a. Connect the modem to the Internet port of the router. The Internet “i” LED on the front of the router should light up. b. Connect the computer to one of th ... HP Pavilion dv8000t Notebook

How to install windows OS on Samsung N128 netbook


My Windows XP installation has reached its half-life. (You do\015\012know that Windows has a half-life, don’t you? Every installation of\015\012Windows naturally degrades along a logarithmic curve until it becomes\015\012annoying, then ... Samsung N120-12GBK Netbook

Forgotten Password need help to unlock my laptop I forgot my password


Good.\015\012If that’s your only problem, then you probably have nothing to worry about. As long as you have your Windows XP CD, you can get back into your system using a simple but effective method made possible by a little known access ... Acer Aspire 3690-2196 Notebook

Cannot log on at all on my acer laptop can anyone help?


I assume u r using winxp.\015\012As long as you have your Windows XP CD, you can get back into your system using a simple but effective method made possible by \015\012a little known access hole in Windows XP.\015\012This method is ... PC Desktops

I have an acer acros pc dated from 1990 to 1995 , the p/n is 91.aa601.r01 and the s/n is 2600308461,ds.AA600.001,it has a classic pent. processor inside ,the problem i have is it does not reboot,when i unplug the keyboard it shows the bios,but when i plug it back in ,the bell is heard or sound, then I restart the system and it still will not reboot,what is my problem??


Hi\015\012i think u have keyboards pin pro change your keyboard.\015\012if your pro is still remain clear the bios setup.check your cmos cell and put away it from its stand for 15 minutes.then restart system your pro is solved.\015 ... PC Desktops

Wireless connection stumble.


Hi dear try this\015\012\015\012Before you attempt\015\012to use any Wi-Fi network, find out what the SSID, Channel, Mode and WEP\015\012key are. Some Wi-Fi locations do not require a WEP key. Many Wi-Fi\0 ... PC Desktops

A D-Link to SMC Wireless Internet Sharing...


Hi deartry this\015\012\015\012Before you attempt\015\012to use any Wi-Fi network, find out what the SSID, Channel, Mode and WEP\015\012key are. Some Wi-Fi locations do not require a WEP key. Many Wi-Fi\01 ... PC Desktops

My lenovo onekey recovery not working?


Hi All, \015\012\015\012I am new to to the community. I recently bought a lenovo G series \015\012machine( G550 model #298595Q preloaded with Windows vista and 320 GB HDD) . \015\012surprisingly The C: drive contained 254 GB of the tot ... Lenovo 3000 Y410 Notebook

I have set up a home network using the Linksys wireless G router. I have networked one laptop to the network with no problem. A second laptop I am trying to connect just will not work. I need help, please.


Hi dear try this way....\015\012\015\012Before you attempt\015\012to use any Wi-Fi network, find out what the SSID, Channel, Mode and WEP\015\012key are. Some Wi-Fi locations do not require a WEP key. Many ... PC Desktops
  • Start your question with What, Why, How, When, etc. and end with a "?"
  • Be clear and specific
  • Use proper spelling and grammar
all rights reserved to the respective owners || www.electronic-servicing.com || Terms of Use || Contact || Privacy Policy
Load time: 1.0132 seconds