Microsoft Windows 98 for PC Logo
Posted on Aug 04, 2008

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 :)

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

  • Contributor 2 Answers
  • Posted on Aug 04, 2008
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Joined: Aug 04, 2008
Answers
2
Questions
0
Helped
1031
Points
4

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

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

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.
0helpful
1answer

Light sockets work if I unclip from metal frame and let hang out of unit

Hi Mark
Check the cables, you will find some loose joints. The light frame/ assembly should be firm, if any part is moving or not sitting in its place, get that corrected. You don't need a rocket scientist to diagnose your problem.
0helpful
1answer

Replace fan motor on radiator

Well replace it then, It doesn,t take a rocket scientist to do it guy,
0helpful
1answer

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.
0helpful
1answer

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.
0helpful
2answers

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.....
2helpful
1answer

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"
0helpful
1answer

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!
0helpful
1answer

A/C delays coming on when adjusting thermostat

"Don't worry about this,, this feature was added tothe outside unit to prevent short cycling, like you're doing now.Mr.Rocket Scientist!.
Not finding what you are looking for?

106 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...