Quote Originally Posted by mancubus View Post
copy the formula in C2 to B2.
Change cell reference C1 to A2.
copy the formula to B3:B10
Thanks for your reply.
The trouble is my 'formula' in C2 is part of an array (matrix) and it cannot be used in suggested by you way. This is a calculator rather than one cell formula. And i want to use this calculator with a range of values and return range of values in te form i mentioned i my quote.
thanks