petshop87
New Member
- Joined
- Aug 29, 2011
- Messages
- 2
I need to auto generate values 0 and 1 in 5 cells based on a single cell
My problem is
IF F1="Independent" 3 of the 5 cells should contain 1 as value
IF F1="Instructional" 2 of the 5 cells should contain 1 as value
IF F1="Frustration" 0 of the 5 cells should contain 1 as value
My problem is
IF F1="Independent" 3 of the 5 cells should contain 1 as value
IF F1="Instructional" 2 of the 5 cells should contain 1 as value
IF F1="Frustration" 0 of the 5 cells should contain 1 as value