G
Guest
I am attempting to use the function DEC2HEX over a range of values.
I know how to use an array formula by selecting the cells that I want for
the formula and then entering the formula, with array variables in the
formualbar. I then hit CTRL-SHIFT-ENTER and the array formula should be
entered in the column of interest.
However, when I use this function, DEC2HEX, I get a #VALUE error. I believe
that the function is expecting a numerical value and not a range index.
=DEC2HEX(A2:A4,4)
How do I work around this?
Thank You
Tom Cipollone
(e-mail address removed)
I know how to use an array formula by selecting the cells that I want for
the formula and then entering the formula, with array variables in the
formualbar. I then hit CTRL-SHIFT-ENTER and the array formula should be
entered in the column of interest.
However, when I use this function, DEC2HEX, I get a #VALUE error. I believe
that the function is expecting a numerical value and not a range index.
=DEC2HEX(A2:A4,4)
How do I work around this?
Thank You
Tom Cipollone
(e-mail address removed)