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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do I subtract vat from amount


If your VAT rate is 20% then divide the Gross by 1.2
60 / 1.2 = 50.

Jul 08, 2014 | Operating Systems

1 Answer

How to download mp3 rocket old version???


You can check out this link for the older versions @ http://mp3-rocket.en.softonic.com/
ie MP3 Rocket 5.3.5, MP3 Rocket 5.2.2, MP3 Rocket 5.1.2, MP3 Rocket 5.03

Hope it is what you need.

May 12, 2011 | Operating Systems

1 Answer

I want to create an if else statement with regards to this problem for ms excel 2007. the conditions are if month>=3 plus 1/2 but if not then minus 1/2.


It seems to have botched your sign before the =3 but lets say that you used "less than" or equal to 3.
(if you used Greater Than, then simply replace "less than" with "greater than" in the example here)

The easiest thing to do is subtract 1/2 no matter what and then say if month is less than or equal to 3 then add 1.
this way, if the month is NOT less or equal to 3, it has already subtracted 1/2, satisfying the "if not" part.
If the month IS less or equal, it adds 1 which compensates for the 1/2 we already subtracted, plus another 1/2 giving an end result of plus 1/2.

This makes it a simple, single if statement that is satisfied in the other direction without having to overcomplicate the issue.

Apr 27, 2011 | Microsoft Operating Systems

1 Answer

122 - (155 - (400 - 637) x 652)= ?


The answer is: -154557

Do the innermost parentethese and work out.

Do multiplication and division before addition and subtraction.

Steps for this are:

122 - (155 - (400 - 637) x 652)=
122-(155-(-237) X 652)
122-(155- (-154524))
122-(154679)
-154557

You can use the Windows calculator on the scientific View and come up with the same answer.

Thanks for using Fixya.

Feb 03, 2011 | Operating Systems

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

Subtract 1.50 from 72.63


Access http://www.google.com
and enter '72.63-1.50' and press ENTER.

Google Math will give you the answer. :-)

Oct 01, 2009 | School Zone Addition Subtraction Full...

1 Answer

Electricity bill coding in java


First think how you would solve this problem yourself on a piece of paper. Then try programming it using the things you learned (if they've given you this assignment without teaching you to multiply, subtract and use if's, drop the course).
Well here is an idea.

Take the total kilowattage and send it to a function. What the function will do is subtract 14KW from the total Kilowattage and add the amount for the first 14KW then subtract 85KW from the total KW and add the amount for the 85KW. But once you subtract the number of KW from the total make sure to check if the total KW isn't negative, if so just break out of the function and return the total due.

Or if you have formula for how much the rate grows over how many miles.

For example lets say the rate grows by $1 every time the KW doubles you could have something like

int rate = 1; //Begining rate
int KW = 14; //First flat rate
int amount; //total amount they have to pay
while(totalKW > 0)
{
totalKW -= KW; //subtract the first rate
if(totalKW <= 0) //check if too much subtracted
break; //if so break
amount += rate; //add the rate to the total

rate += 1; // Add $1 to the rate every time
KW *= 2; // KW is doubled
}

Jan 05, 2009 | Operating Systems

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 Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Carlos L. Burgos
Carlos L. Burgos

Level 2 Expert

508 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...