Hey Danny,
So, you are saying to create like a chart in the corner of the spreadsheet
ao If I enter a letter in a cell it will recall what the value is from the
chart?

Giggles

"Danny Lewis" wrote:

wow that didnt show my explanation at all lol

create a table from A1 to B16
with numbers 16 to 1, descending in column A
and letters from A to P in column B

in D5 put your number of units attended eg 15

in D6 put =VLOOKUP($D$5,$A$1:$B$16,2,FALSE)

And your grade ie in this case B, will come up. Any time you change D5 now,
D6 will change.

Danny
"Danny Lewis" wrote:



"tim m" wrote:

=IF(A115,"A",IF(A113,"B",IF(A111,"C",IF(A19,"D ",IF(A1<10,"F",0)))))

You could try something like this, it looks at cell A1 and if the cell is
15 it assigns and A, if it is 13 it assigns a B, etc.

The actual look of your formula will depend on what letters you are
assigning to which numbers and how many letters you have.

"Giggles" wrote:

I have a spreadsheet that keeps attendance. Now I need to calculate the
units (1 unit= 15 minutes) the children are actual here. On a normal
schedule they are here for 16 units but if the are late the units get
subtracted. When entering the data, they would like to use letter instead of
numbers. Is this possible?