Problem with CHOOSE function

SGH

Board Regular
Joined
Dec 11, 2003
Messages
72
I have a CHOOSE formula in
H19 =CHOOSE(K19,L19,M19)
K19 displays the value 1
L19 displays the value 205
M19 displays the value 204

the result of the formula in H19 diplays 0
But when you enter the formula using the funtion wizard it says the answer is 205, I think i'ts to do with the format of the cells but these are all set to general, any ideas ?
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Hello,

This won't solve your problem, but the only way i get a 0 is to have no text in cell L19. I have created the CHOOSE formula several ways and always get 205.

Are you sure you chose the correct cell when not using the Wizard?
 
Upvote 0
as per onlyadrafter's reply, the format of the cells shouldn't make a difference - describe exactly what you've done etc...
 
Upvote 0
The cells K19, L19 & M19 are the results of other formula.

H19 was blank, I used the Formula wizard & picked the CHOOSE function
which whilst still in the wizard gave the correct answer of 205, I click OK to exit the Formula wizard & the cell displays '0'.
 
Upvote 0
weird - & there's really nothing else going on? what happens if you try the formula in another cell?
 
Upvote 0
Again, I get the correct answer through Formula Wizard but click OK to exit it & I get 0 again !
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,072
Members
448,546
Latest member
KH Consulting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top