Need Formula Help

[JJSCOTT2]

I would appreciate it if someone could take a look at this formula an
see if they can figure out why its not working.



=IF(I10>89, “A”, IF(I10>79, “B”, IF(I10>69, “C”, IF(I10>59, “D”
“F”))))

This is for a grade book type worksheet which is the signifigance o
the numbers in the formula.

Thanks.

Justi

 

[Frank Kabel]

Hi
the formula looks o.k. for me (besided 'E' is missing). What problem do
you have with this formula?

 

[Chip Pearson]

Justin,

Your formula seems to work fine for me. Perhaps you could be a
bit more specific when you way that it doesn't work.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

Justin

This works for me.

=IF(I10>89,"A",IF(I10>79,"B",IF(I10>69,"C",IF(I10>59,"D","F"))))

When I copy your formula from this post, I get some funny backwards quote
marks. Don't know if that is your system or the news reader.

Another method is.........

Example only........

=VLOOKUP(B1,{30,"F";40,"E";50,"D";60,"C";70,"C+";80,"B";90,"B+";100,"A"},2)

B1 is the score. For a column of scores just drag/copy the formula down.

Adapt to your ranges of scores/grade letters.

Gord Dibben XL2002

 

[Ken Wright]

The quotes come across as CODE value 34 for me, instead of 147. I replaced them
with fresh quotes using SHIFT+2 and it works fine.

 

[David McRitchie]

Your double quotes are incorrect, they should be straight quotes,
not 66---99 quotes whatever they are called.

 

[JJSCOTT2]

Thanks alot

 

[CLR]

When I copied and pasted your formula to my sheet it would not work at first
because it had an extra space .....79, "B" instead of 79,"B".............I
fixed that and it worked just fine in XL2K..........

Vaya con Dios,
Chuck, CABGx3

 

[David McRitchie]

The technical term is "Open double quotes" and "Close double quotes"
as opposed to double quotes which you need. I thought there might be
another term rather than the obvious. As a programmer we alway said
open and close quote just so there was no mistake but they were always
plain typewriter/keypunch double quotes.

You can see the difference if you copy and paste into notepad or as I did
into Edit Pad Lite.

The top is the original with open and close double quotes
=IF(I10>89, “A”, IF(I10>79, “B”, IF(I10>69, “C”, IF(I10>59, “D”, “F”))))
The following is what I tested with after fixing quotes
=IF(A10>89, "A", IF(A10>79, "B", IF(A10>69, "C", IF(A10>59, "D", "F"))))
my verification after the fact was pasting into a text editor.

 

[Gord Dibben]

David

I liked the term 66 and 99 you originally came up with<g>

Those were what showed up when I copied the original formula. Like you, I
changed to regular d-quotes and formula was OK.

Gord

 

[CLR]

......and yet, I had no trouble with the "quotes" or "doublequotes", or
whatever..........as I said, I just deleted the extra blank space from the
OP's formula and it worked fine for me........wonder why?..........I'm using
WinMe and XL2k.

Vaya con Dios,
Chuck, CABGx3

 

[David McRitchie]

Hi Chuck,
Okay when I pasted into OE all quotes were changed to typewriter
double quotes. I guess you have to use the original posting.

The original posting was through ExcelTipForum a web based
interface, but it was posted in plain text.

Had you originally used the original.

 

[CLR]

Hi David........

I used the OP's first post here in this newsgroup which showed up on my
screen at 5:25pm 3/13/04.

I dont follow that other group you mentioned.

I guess OE5 just proved once again that my computer is smarter than I am
(groan).........it even TOLD me what was wrong with the formula by
highlighting the extra space.......

Thanks for the explanation.........


Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Change your numbers to 88,78,68,58

 

[kidd]

I am trying to make a formula that adds the amount at 200 and then th
amount if it double and triples without a limit.

Example: 1=200 /2 = 200+400/ 3 = 200+400+600/ 4 = 200+400+600+800 /
= 200+400+600+800+1000/ 6 = 200+400+600+800+1000+1200

If they enter in A1 the number 4

then in C1 then answer should be 2000

If they enter in A1 the number 6
then in C1 the answer should be 4200

Can anyone HELP ME PLEAS

 

[Guest]

Hi, kidd. You are describing an arithmetic series in the form of
n*(n+1)*100. So if the value n is in cell A1, then the formula in C1 would
be =A1*(A1+1)*100.

 

[Myrna Larson]

What you have are describing is (the sum of digits from 1 to N) * 200.

The equation for the sum of the digits is (N+1)*N/2.

The logic is very clever. Create pairs by selecting 2 numbers from the
original N values, but don't do it at random: do it by pairing 1 with N, 2
with N - 1, 3 with N - 2, etc.

Note that the sum of each pair is N + 1 (e.g. 5 + N - 4 = N + 1)

So, if you know how many pairs there are, the total is (N+1) * number of
pairs. The number of pairs = N/2.

So the sum of the digits from 1 through N, inclusive is (N+1)*N/2

If you put N in cell C1, the formula for A1 is

=200*C1/2*(1+C1)

 

[kidd]

garfield-n-odie thanks SO MUCH YOUR THE BEST :

 

[kidd]

I have my entire file now complete and everything work perfectly but
need this to be on the web where people enter 2 numbers in 2 cells an
then the rest is figured out for them. When I save as webpage it show
up but no one can enter text in the 2 cells I need them too. Can anyon
help???