View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jolly Jolly is offline
external usenet poster
 
Posts: 19
Default circular formula gives different values

I have a circular reference in my worksheet where I get two sets of values
for the same input as the circular flips between two values. I have set the
iteration to 100 but the values in the sheet do not give the same answer each
time.