Hi,
I have been given a sample of data. I would like the end user to enter in to two cells (B2 and B3) and the third cell (B4) would give the answer. One of the probelms I have is that I ahve a set of numbers grouped in one cell (B7). I just want to pick one of those numbers. An example is below. Is there a formula that could be placed in cell B4 that would give the correct answer of 4500 please?
Thanks for any help,
James
I have been given a sample of data. I would like the end user to enter in to two cells (B2 and B3) and the third cell (B4) would give the answer. One of the probelms I have is that I ahve a set of numbers grouped in one cell (B7). I just want to pick one of those numbers. An example is below. Is there a formula that could be placed in cell B4 that would give the correct answer of 4500 please?
Thanks for any help,
James