Microsoft Office Excel 2003 for PC Logo

Related Topics:

Posted on Mar 31, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Too many nests

I tried to do this and failed. It is supposed to assign SATS levels from mark scores.
Apparently a max of 7 "nests" is available???????

=IF(H2>130,"7a",IF(H2>109,"7b",IF(H2>86,"7c",IF(H2>75,"6a",IF(H2>64,"6b",IF(H2>53,"6c",IF(H2>46,"5a",IF(H2>38,"5b",IF(H2>31,"5c",IF(H2>25,"4a","N"))))))))))

Don't tell me I need to buy "Excel for Dummies" I know that already!!!!

Rob

  • nunneries Mar 31, 2009

    Very useful advise thank you!

×

1 Answer

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

  • Expert 145 Answers
  • Posted on Mar 31, 2009
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

Joined: Mar 12, 2009
Answers
145
Questions
1
Helped
45155
Points
398

Try a lookup instead. In this example, If the value in A2 < 60 then the grade would be F.

=LOOKUP(A2,{0,60,63,67,70,73,77,80,83,87,90,93,97},{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"})

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2helpful
2answers

I cant get zone 2 to work on my yamaha rx v673. They are 2 outdoor speakers.. please help

I had a similar problem where I could not increase zone 2 volume - Page 100 in the manual notes that 'power amp assign' must be set to "7 Ch + 1 zone" before zone 2 max volume can be changed. Try that.
0helpful
2answers

Can one be raised in a certain environment that would increase chances of having a greater IQ?

IQ is supposed to be a measure of intelligence and according to the theory we are born with a fixed amount of intelligence which cannot be increased by environment. However the original IQ tests were based on how well people responded to knowledge based questions, (e.g. they would need to have read popular books of the time to know the answers) which gave an advantage to people who lived in the same type of society as those who created the tests i.e. white western middle to upper class society. Modern IQ tests try to be more global and to be unbiased in that they avoid asking questions based on knowledge only available to some people. However even these IQ tests are flawed because as a measure of their accuracy they were designed to produce the same results as the earlier types. So for example a person who scored high on the original tests had to score high on the newer types for them to be considered accurate.

So to answer your question the type of environment a person is raised in can influence their IQ scores. For example if a child is raised in an environment which challenges them to remember, work out problems, where they are spoken to a lot by adults preferrably not using baby talk, where they read a lot etc. they will develop the skills necessary to increase their IQ. Adults can increase their performance in IQ tests also. There are books on how to e.g. http://www.amazon.com/IQ-Booster-Improve-Performance-Dramatically/dp/0806994223 However do not mistake IQ scores with intelligence levels. Some people can score highly in one area of IQ tests and score low in other areas giving them a low average. Some people who score high average IQ scores do poor in school examinations while others with low IQ scores do well. Do not get caught up too much in worrying about IQ scores. More important is having a well balanced happy child which is more likely to result in a successful adult.
0helpful
1answer

I need a wiring harness diagram. am trying to straighten out last owners rats nest. they changed motors and apparently made things up as they went along. nothing is where its supposed to be and nothing...

Hi, the diagrams below are available at autozone.com, or I can send them to you in their original resolution if you reply with your email address.

jturcotte_1462.gif

jturcotte_1464.gif

jturcotte_1465.gif

jturcotte_1466.gif
0helpful
1answer

Describe how you could measure a distance of about 1 km in your neighbourhood

To measure it accurately use the longest measuring tape you can find (I have one that measures 30m). Extend it fully and starting from the beginning point lay this in the direction you wish to measure the road. At the 30m mark on the tape lay a tooth pick, or some other item with a sharp point, on the road with the point level with the 30m mark on the tape. Now without moving the toothpick hold the tape and walk in the direction you wish to measure until the beginning of the tape is level with the toothpick (check that this is accurate - best if you have somebody helping you).Now take the tooth pick and again place it on the road level with the 30m mark on the tape. Repeat this another 31 times and then on the next time measure only one metre. This will have taken you 1000 metres along the road.
Alternatively, make your self a wheel of circumference say one metre out of some suitable material (plywood). Attach an axle at the centre with a handle so that this wheel can easily revolve on the axle. Put a mark on the wheel at the circumference so that when you place the wheel on the road with this mark at your starting point on the road and then walk forward, you will be able to count the number of times it has rotated as you walk along in a straight line. When the wheel has completed 1000 rotations (with this mark touching the road) this is the 1 Kilometre distance measured.
Posted on Jan 24, 2015


homeworkhelpcom_super_tutor_high_1247104.jpg

My Dashboard


avatar2.jpg1
Felix Yusupov
  • Answers: 13
  • Points: 24
  • Level: 1
142 people helped
76 more points to advance to level 2

  • Level 1
  • Level 2
  • Level 3
6 points to next milestone Assistant
My Milestones initiate_3.png Progress to Expertise
  • Android Communication Apps
  • Yahoo
  • Printers & Copiers
  • Internet & Communication Software
  • Websites
  • Educational & Reference Software
  • Canon
  • Google
  • meez.com
  • Scanners
  • SuperTutor
  • IBM
  • My Achievements
  • 41-the-more-the-merrier.png
  • 03-problem-solver.png

  • View all achievements » Top 5 Fixya Experts This Week avatar8.jpg
    kakima
    • Answers: 97523
    • Points: 428884

    4868 Score harriem.jpg
    Harrie
    • Answers: 4267
    • Points: 26949

    1262 Score avatar8.jpg
    ray gallant
    • Answers: 724
    • Points: 3249

    1001 Score gopakumarg43_1.jpg
    The Knight
    • Answers: 42346
    • Points: 130745

    919 Score motogenius_1.jpg
    Motorola...
    • Answers: 1593
    • Points: 8494

    667 Score avatar2.jpg
    Felix Yusupov
    • Answers: 13
    • Points: 24

    20 My Score View Full Leaderboard »
    0helpful
    3answers

    How do I refill my TRansmission Fluid?

    There is no reservoir...fluid is added right into the tube for the dipstick with a funnel.
    0helpful
    1answer

    Boot off IDE with SATS drives present

    I tried to put ide with SATA and got the same I think IDE and SATA do not mix unless you know how to set up.
    Easiest and cheapest in long run use one type of drive
    Not finding what you are looking for?

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