Hey Tim,
I tired the formula but it is kind of coming out oppiste of what I need.
Let me give more detail. everyday I want to be able to place a letter in a
cell that represents how many units that child used for that day. for
example if I place a A in cell a1 then in another cell at the end of that row
it will calcutale that A means she used 16 units that day. I hope the msake
better sense.

giggles

"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?