Help with formula with school notes

Hi O,

Here's the sticking point:

"when i enter a number it's shows in the same cell the note..."

In Numbers, a cell may contain a formula (and display the result that formula calculates), or it may contain a value entered directly into the cell using the keyboard or by pasting. It can't contain both.

It is possible, though to put a formula into a cell that would return the letter grade when a second cell contains a number. That number could be calculated, or could be entered directly.

You'll find instructions on how to do this here: Re: Multiple functions?

Regards,

Barry

The most straightforward way to have it happen within the same cell is to make a custom format. Unfortunately, it is limited to only four conditions so you could do A+, A, A- and B but not the rest. Or you could have A,B,C,D but not F. Doesn't quite solve the problem.

Another possibility for "one cell" operation would be to have overlapping tables. The top table and the text within it would be set to be invisible (no fill, text opacity of zero, etc). You would enter the numeric grades in this table. The table underneath would do a close-match VLOOKUP on the numeric grade (using a lookup table) and display the corresponding letter grade. This is a little bit kludgy but if you need it to be in a "single cell", it will do it. Personally, I'd not do it this way, I'd use two columns (one for the number, one for the letter) and a lookup table because it is simpler. Especially if it is for someone else's use.

Here's a screenshot of the basic idea. Notice how the selected cell appears as an A+ but the formula bar has it as 96. Table 1 is the bottom table, Table 2 is on top of table 1 and is where you enter the numbers, and table 3 on the right is the lookup table. When Table 2 is not selected, it will disappear.