Thanks to you both for the reply, and you are both right. The example that
was for you to see how i could join them into one formula. But I can now see
that only 7 nested functions can go in one formula. So is it Possible to do
this in vb knowing that there will be about 12 functions to be calculated for
each row.

Thanks again in advance

Allan