Question about Microsoft Windows 98 for PC

# An IF Then question

Hi. I am not a rocket scientist -- of for that matter, very good with addition and subtraction, and I have to take a test for my job. Well, retake the test...
So, question, in Excel (and the test uses Windows 98), I need to create a formula that will place the word "yes" if the sales team meets or exceeds goal of \$3000, and the word "no" if they do not. HELLLLLPPPPP! Thanks :)

Posted by on

### Anonymous

• Level 1:

An expert who has achieved level 1.

• Contributor

Assumed I have this sheet below:
|   A       |     B
=====================
1 | SALES   |   GOAL
2 |       3000 | =IF(A2>2999,"YES","NO") -> copy too all cell below
3 |       2000 | =IF(A3>2999,"YES","NO")
4 |       2999 | =IF(A4>2999,"YES","NO")

Will be displayed as:

|   A       |     B
=====================
1 | SALES   |   GOAL
2 |       3000 | YES
3 |       2000 | NO
4 |       2999 | NO

Posted on Aug 04, 2008

×

my-video-file.mp4

×

## Related Questions:

### How do some scorpions glow when light shines on it?

Do scorpions glow? Yes. That's an easy question to answer. It's a bit more difficult to pin down what exactly causes them to glow. In fact, scientists are still working on finding a firm answer to that question.

What scientists do know is that something in the scorpions' exoskeletons cause them to glow. Scorpions, along with other arthropods and insects, have an outer layer called a "cuticle." Unlike the cuticles on your fingers, which are made of hard or dead skin, the cuticle on a scorpion is a part of its exoskeleton. This cuticle has a thin section called the "hyaline layer." The hyaline layer is what reacts to ultraviolet (UV) light, such as black light or moonlight, and causes the scorpion's body to glow.

The hyaline layer is really strong and truly stands up to the tests of time. In fact, scientists have found that even fossilized scorpions glow under UV light. Additionally, when scientists preserve scorpion specimens in liquid-filled jars, the hyaline layer can make the liquid glow! Crazy, right?

While observing scorpions, scientists have noticed that the creatures don't glow immediately after molting. Rather, the cuticles have to harden completely before they shine blue-green in the starlight. But scientists still don't know if the glowing material comes from a chemical reaction in the hardening process, or if the scorpions actually secrete the glowing substance.

May 14, 2017 | Cars & Trucks

### Replace fan motor on radiator

Well replace it then, It doesn,t take a rocket scientist to do it guy,

Nov 28, 2012 | 1999 Lexus RX 300

### I need a replacement for my usb dongal [receiver]

I suspect that Dongle is used on a specific program. Dongles are used for coding and exacting information. You will need more knowledge than a rocket scientist to copy one.

Feb 20, 2011 | Computers & Internet

### Prev owner says he would set temp for freezer at lowest setting. Said he had to recharge annually. It is an Amana R-134 system. Can I use over the counter refrigerant with "Stop Leak" additive?...

The only way you can loose refrigerant is by a system leak.
Call factory service and have them check it out. They will install a drier with uses a special dye to find the leak. It is the only manufacturer approved additive.

Dec 20, 2010 | Refrigerators

### Hi there my hotpoint 640 is leaking it was leaking first at front but now the cold water connection at the back is leaking too.any ideas thanks

Fit a new hose or a new washer onto the old hose ...assuming that is the source of the leak that should cure......Good luck.....

Dec 10, 2010 | Washing Machines

### Order of opertions.. directions:which operation should you do first?write +,*,-,or / 1. 25/5*8

It does not matter what sequence you write in. The sequence followed by all is BODMAS. Brackets, Of, Division, Multiplication, Addition and Subtraction.
What matters is that you should separate the * and / from + and - with the help of brackets.

Jun 23, 2010 | Mathsoft Solving and Optimization...

### How do you subtract low numbers from high numbers

• Hi, to "Subtract a >Higher (#,\$) numbers from a <Lower (#, \$) numbers; you take the "bigger number 167, place that number (over the smaller number 78 and from (right to left) take away numbers. Example: 167 - 86 = Think of 167 as \$167.00 and 86 as \$86.00, so to make \$86.00 into \$167.00 you'll need a \$81.00 more. So if you think about how much more money you will need to "Add" to make a certain amount, it is just the same as how much you "Don't have! You have \$167.00 when you go shopping for clothes, and you spend \$86.00 when you count how must money you have left, it add up to \$81.00 "That's "Subtracting." "Subtract (167 from 86 you get 81). " Always remember the Higher, or Larger number goes on top! " If you want to check to see if the answer is "right," add the two number together,(86 + 81 = 167). "I hope this helped you, rating the solution is appreciated, thanks"

May 02, 2010 | School Zone Addition Subtraction Full...

### Voice memo, Itunes and Ipod

no sorry buddie im not a rocket scientist... lol im just some nerd on the computer trying to act smart!

Aug 27, 2008 | Apple iPod MA446LL/A MP3 Player

### A/C delays coming on when adjusting thermostat

Aug 21, 2008 | Coleman Heating & Cooling

#### Related Topics:

96 people viewed this question

Level 3 Expert

Level 3 Expert