Is there a way to refer to nonadjacent cells as an argument in XIRR formula?
B Bob Phillips Nov 4, 2003 #2 Tomek, Have you tried putting the ranges in brackets, e.g. (A1:A10, B3:F3) as your values -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Tomek, Have you tried putting the ranges in brackets, e.g. (A1:A10, B3:F3) as your values -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)