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

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

If your VAT rate is 20% then divide the Gross by 1.2

60 / 1.2 = 50.

60 / 1.2 = 50.

Jul 08, 2014 | Operating Systems

Had the same problem.. not loading until 15%.. What is there to be done?

Sep 18, 2011 | Operating Systems

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.

ie

Hope it is what you need.

May 12, 2011 | Operating Systems

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.

(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

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.

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

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

Access http://www.google.com

and enter '72.63-1.50' and press ENTER.

Google Math will give you the answer. :-)

and enter '72.63-1.50' and press ENTER.

Google Math will give you the answer. :-)

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

using switch case statement is possible.

Jan 29, 2009 | Operating Systems

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

}

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

Jun 15, 2014 | Microsoft Windows 98 for PC

Apr 27, 2014 | Microsoft Windows 98 for PC

86 people viewed this question

Usually answered in minutes!

×