3 different cells, 1 random value

[Schaetzchen]

Hey guys,

I have a quick question

I have 3 cells - A1,A2 and A3. ONE of these cells will contain a random value (depending on a condition that is already scripted). Now I want that random value, which can be in any of those 3 cells, to be in a new cell (A4 f.e.). How would that work?


Kind regards
Steffi

[TheCman81]

Will A1:A3 only have 1 value and the other 2 blank?

if so just use =SUM(A1:A3)

If not, can you supply some sample data

Thanks

[Schaetzchen]

Thanks for the reply!

Yes, only one cell will have a value. But I forgot to mention that it can be a number or a letter (specifically, A1 can only be "1" or blank, A2 can either have "X" or blank and A3 may have "2" or blank) .. thus the sum function won't work

[TheCman81]

Use the following array formula, let me know if this is what you need =SUM(IF(ISNUMBER(A1:A3), A1:A3))

[XOR LX]

Hi,

=LOOKUP(1,0/(A1:A3<>""),A1:A3)

Regards

[Tony Valko]

If there are only 3 cells to check you can also use a nested IF formula.

=IF(A1<>"",A1,IF(A2<>"",A2,IF(A3<>"",A3,"")))

The expression <>"" means "is not blank".