Problem with =IF formula <<

Hello everyone,
I am a new member here.

72-years-old. Don't use my laptop much, hence I still have Office 2007.
However, I decided to try and study Excel, to exercise my mind, and have fun.

So I hope you can find time to help me with this problem.
my existing test set-up, which works just fine ...

B1 - contains a random 4 digit number (eg: 1999)
B2 - contains the last 2 digits of this number (eg: 99) using =RIGHT(B1,2)
B3 - contains the contents of B2, minus 84 using =IF(B2>90,B2-84,"")

this is where my problem begins ...
I tried to modify the existing formula in B3

from
=IF(B2>90,B2-84,"")

to
=IF(B2<60, "F", IF(B2<70, "C", IF(B2<80, "B", IF(B2<100, "A"))))

CONS: FALSE statement ... it doesn't work, because I think that although the contents of B2 is a number, the cell contains a formula?
However, it worked just fine with the previous formula ... ?

PROS: it does work if I remove the formula =RIGHT(B1,2) from cell B2 and just enter a number manually in that cell


Is there a way to overcome this issue, please?
Any help will be much appreciated.

Thank you
Geoffrey

Welcome to the forum.

Hard to tell without seeing a sample.

Are you really using Excel 2007?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

A guess whilst waiting for a sample workbook:

=LOOKUP(--B2,{0,60,70,80},{"F","C","B","A"})

I am not convinced that you have set the criteria correctly, though ...

in B2

Formula:

Please Login or Register  to view this content.

converts TEXT to NUMERIC

then your formula will work

What about the solution I offered? That should work, too.

=LOOKUP(--D2,{0,60,70,80},{"F","C","B","A"})

Administrative Note

Please don't ignore contributors to your thread - it takes members time to provide suggestions, so acknowledge all solutions offered, even if they don't meet your requirements. Thanks.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Please see post #6 for instructions about how to sign off this thread.