Dear Experts
I am using a choose Formula as follows:
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),0.65,0.6,0.55,0.5,0.45,0.4)
At the end of formula I have few fixed factors which i want to name as Set A, Set B, Set C as follows:-
<colgroup><col><col></colgroup><tbody>
</tbody>
Now I want to use the choose formula as follows for various sets as state above:-
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),Set A)
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),Set B)
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),Set C)
Is it possible? Can somebody help in this regard?
I am using a choose Formula as follows:
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),0.65,0.6,0.55,0.5,0.45,0.4)
At the end of formula I have few fixed factors which i want to name as Set A, Set B, Set C as follows:-
Set A | 0.65,0.6,0.55,0.5,0.45,0.4 |
Set B | 0.7,0.65,0.6,0.55,0.5,0.45 |
Set C | 0.6,0.55,0.5,0.45,0.4,0.35 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Now I want to use the choose formula as follows for various sets as state above:-
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),Set A)
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),Set B)
CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),Set C)
Is it possible? Can somebody help in this regard?