Question about Microsoft Windows 98 for PC

1 Answer

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

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

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

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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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.

Oct 08, 2014 | Viking VCWH3048WH 30" Wall Mount Chimney...

1 Answer

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

1 Answer

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

1 Answer

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

2 Answers

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

1 Answer

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...

1 Answer

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...

1 Answer

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

1 Answer

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!.

Aug 21, 2008 | Coleman Heating & Cooling

Not finding what you are looking for?
Microsoft Windows 98 for PC Logo

86 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18354 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...