| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable statement
I need a fn to substitute for a variable value in a SUM fn., in other words
my problem as indicated in below table (Hrs) 2 2 3 1 Student X X1 X1 X2 X1 Y X2 X2 X1 X2 For example, We have 2 students (X&Y) & Courses of different time duration(2,2,3 & 1) hrs and the times of repetition for each course is X1 & X2 So, for student X, the total hours will be 2*X1+2*X1+3*X2+1*X1= (hrs) so, how to substitiue for X1 & X2 values in Excel sheets? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable in if statement | Excel Worksheet Functions | |||
| IF Statement Variable | Excel Discussion (Misc queries) | |||
| How to pass a variable into an SQL statement | Excel Discussion (Misc queries) | |||
| if than statement has too many variable | New Users to Excel | |||
| Add 2nd variable to if statement - ifAnd? | Excel Worksheet Functions | |||
Threaded Mode
