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?

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

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

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?

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?

Thanks Danny,
for teaching me how to use LOOKUP, I'm sure I'll use it in the future.

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?

Thanks Tim I'll try that.
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?

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?

=IF(E1="A",16,IF(E1="B",15,IF(E1="C",14,IF(E1="D", 13,IF(E1="F",12)))))

You could try something like this however the more effecient method would be
to use Danny Lewis's way of creating a table and using a VLOOKUP formula.

"Giggles" wrote:

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?

Thanks Tim That worked out Perfect!!!

Giggles

"tim m" wrote:

=IF(E1="A",16,IF(E1="B",15,IF(E1="C",14,IF(E1="D", 13,IF(E1="F",12)))))

You could try something like this however the more effecient method would be
to use Danny Lewis's way of creating a table and using a VLOOKUP formula.

"Giggles" wrote:

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?