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 ?
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 ?