Need help with Excel formula

[Sher]

I am trying to write an IF formula for Excel (Office 2000 if that makes a difference) that will look in boxes and IF something is in box 1a, then it will report box 1b ... IF something is in box 2a, then 2b ... etc. This is so that as the Average changes in my grade book, it will update the GPA from the following table:

A+ 100 4.00
A 99 3.95
A 98 3.90
A 97 3.85
A 96 3.80
A 95 3.75
A 94 3.70
A 93 3.65
A 92 3.60
A 91 3.55
A- 90 3.50
B+ 89 3.4
B 88 3.3
B 87 3.2
B 86 3.1
B 85 3
B 84 2.9
B 83 2.8
B 82 2.7
B 81 2.6
B- 80 2.5
C+ 79 2.4
C 78 2.3
C 77 2.2
C 76 2.1
C 75 2
C 74 1.9
C 73 1.8
C 72 1.7
C 71 1.6
C- 70 1.5
D+ 69 1.4
D 68 1.3
D 67 1.2
D 66 1.1
D 65 1
D 64 0.9
D 63 0.8
D 62 0.7
D 61 0.6
D- 60 0.5
F < 60 0

So ... if the grade is a 71, it will automatically report a 1.6 in the column next to it. I can't get it to work right because there are too many IFs in the formula the way I was doing it ... :help: There has to be a workaround this, doesn't there?

[$cirisme]

You can do that?

And all this time I thought Excel was a useless waste of space. :teeth:

[Sher]

:argh: not helping ...

[Em7add11]

Ahh man, I had to do something like this once with the LOOKUP function. It's been so long that I can't remember exactly how it should go, but the basic idea is this:

LOOKUP(lookupvalue, search-range, answer-range)

More details are in the help files. :teeth:

[Sher]

Yesterday @ 08:37 PM post located here (http://www.theologyweb.com/forum/showthread.php?s=&postid=99081#post99081)
Em7add11:

Ahh man, I had to do something like this once with the LOOKUP function. It's been so long that I can't remember exactly how it should go, but the basic idea is this:

LOOKUP(lookupvalue, search-range, answer-range)

More details are in the help files. :teeth:

Cool ... that gives me a place to start :thumb:

[Em7add11]

Today @ 01:07 AM post located here (http://www.theologyweb.com/forum/showthread.php?s=&postid=99210#post99210)
SherBear:

Cool ... that gives me a place to start :thumb:
I just hope I remembered the name of the function correctly.

[Sher]

Today @ 03:22 AM post located here (http://www.theologyweb.com/forum/showthread.php?s=&postid=99230#post99230)
Em7add11:

I just hope I remembered the name of the function correctly.

:kiss: You did! It is a Lookup vector that I was looking for:

LOOKUP(lookup_value,lookup_vector,result_vector)

It is working ... I just need to tweak it a bit ... it reports for 84 even if it is over 84.5 (which should report for 85) ... but the basics are there for me ... :yipee:

[Em7add11]

Awesome! :bunny:

[$cirisme]

05-16-2003 @ 04:46 PM post located here (http://www.theologyweb.com/forum/showthread.php?s=&postid=99019#post99019)
SherBear:

:argh: not helping ...

So what's your point?

I have problems to, but does anyone ever offer to help me! No!

It's always ciris this, ciris that; does anyone care about me!?!?!

:eek:


:brow:

[Sher]

Today @ 01:13 PM post located here (http://www.theologyweb.com/forum/showthread.php?s=&postid=101252#post101252)
cirisme:

So what's your point?

I have problems to, but does anyone ever offer to help me! No!

It's always ciris this, ciris that; does anyone care about me!?!?!


:kiss: Feel better?

[prgmrdave]

05-19-2003 @ 10:13 AM post located here (http://www.theologyweb.com/forum/showthread.php?s=&postid=101252#post101252)
cirisme:



So what's your point?

I have problems to, but does anyone ever offer to help me! No!

It's always ciris this, ciris that; does anyone care about me!?!?!

:eek:


:brow:

YES! I just don't know PHP, is all! :frown: