Does CHOOSE() work with selecting formula rather than text

jts2004

Board Regular
Joined
Apr 21, 2004
Messages
156
Does CHOOSE() work with selecting formula rather than text

EX: =choose(1,A1+5,A2+10,vlookup(A4,range,2,false) ect......if 10 were in A1 than the answer would be 15.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,948
Members
412,299
Latest member
agentless
Top