Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an algebraic substitution for use in formulas
I'm trying to create a spreadsheet in Excel where P=0.5, A=0.5 and N=0. I
would like to assign these values (somehow) and add up the letters to give me a numerical sum in the end cell, eg. N+P+P+A+P+A=2.5. How can I accomplish this? Alternately, can I use symbols, such as checkmark signs, etc., as substitutes for numbers? (To understand the practical application, I'm a music teacher trying to create an attendance sheet for my studio that uses their letters/symbols to denote attendance, while still being able to add up the total amount of hours for my own invoice purposes.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an algebraic substitution for use in formulas
Insert/ Name/ Define/ P/ refers to: 0.5
Similarly define A and A Then you can use a formula =N+P+P+A+P+A and get the result 0.5 -- David Biddulph "KfoozyGirl" wrote in message ... I'm trying to create a spreadsheet in Excel where P=0.5, A=0.5 and N=0. I would like to assign these values (somehow) and add up the letters to give me a numerical sum in the end cell, eg. N+P+P+A+P+A=2.5. How can I accomplish this? Alternately, can I use symbols, such as checkmark signs, etc., as substitutes for numbers? (To understand the practical application, I'm a music teacher trying to create an attendance sheet for my studio that uses their letters/symbols to denote attendance, while still being able to add up the total amount of hours for my own invoice purposes.) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an algebraic substitution for use in formulas
Okay, that worked...now, how do I create an autosum as I normally do (by
highlighting the cells and pressing the AutoSum button)? Example: 1st Week 2nd Week 3rd Week 4th Week 5th Week Total N P P A P 2.0 I can only create a manual formula so far and I'd much prefer to use these substitutions with AutoSum. Also, can you define the same symbol (such as P) with different numbers, depending on the row or column you are in? I want P to stand for 0.75 or 1 with some of my students as well. "David Biddulph" wrote: Insert/ Name/ Define/ P/ refers to: 0.5 Similarly define A and A Then you can use a formula =N+P+P+A+P+A and get the result 0.5 -- David Biddulph "KfoozyGirl" wrote in message ... I'm trying to create a spreadsheet in Excel where P=0.5, A=0.5 and N=0. I would like to assign these values (somehow) and add up the letters to give me a numerical sum in the end cell, eg. N+P+P+A+P+A=2.5. How can I accomplish this? Alternately, can I use symbols, such as checkmark signs, etc., as substitutes for numbers? (To understand the practical application, I'm a music teacher trying to create an attendance sheet for my studio that uses their letters/symbols to denote attendance, while still being able to add up the total amount of hours for my own invoice purposes.) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an algebraic substitution for use in formulas
In A1:A3 (for example) enter the letters A, N, P
Next to each, enter numeric values Select A1:B3 and use Insert | Name | Create Now B1 is called A, B2 is called N and B3 is P In some other cell enter =N+P+P+A+P+A and out pops 2.5 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KfoozyGirl" wrote in message ... I'm trying to create a spreadsheet in Excel where P=0.5, A=0.5 and N=0. I would like to assign these values (somehow) and add up the letters to give me a numerical sum in the end cell, eg. N+P+P+A+P+A=2.5. How can I accomplish this? Alternately, can I use symbols, such as checkmark signs, etc., as substitutes for numbers? (To understand the practical application, I'm a music teacher trying to create an attendance sheet for my studio that uses their letters/symbols to denote attendance, while still being able to add up the total amount of hours for my own invoice purposes.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating IF formulas in excel | Excel Discussion (Misc queries) | |||
Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
follow-up from yesterday's "creating formulas" | Excel Worksheet Functions | |||
Creating Formulas | Excel Worksheet Functions | |||
Creating Formulas for overtime | Excel Worksheet Functions |