Tuesday, November 5

Tag: function choose

Choose Function In Excel

Choose Function In Excel

FORMULAS, Lookup & Reference
DEFINTION:- The Excel Choose Function Returns A Value From A List Using A Given Index Number Or A Position. Example 1 =Choose(2,"Car","Bike","Plane") Returns "Bike", As Bike Is On 2Nd Position Listed In The Value Parameter. This Way You Can Assign The Index Number And Thereafter A Value As A Sequence. Example 2 =Choose(C68,"Car","Bike","Plane") Returns "Car" Because The Cell Reference Having A Index number 1 And Car Is On 1st Position Listed In The Value Parameter. This Way You Can Assign The Index Number And Thereafter A Value As A Sequence.