Ok Zujar,
Thank you.
I have asked it for my formula to not change in date based on current date.
But I think it is not good option for me because it will affect all the
excel workbooks.
Column 'c7' contains today formula for current date.
in column 'b' I have inserted a formula from cell 'b8' =c7 respectively till
cell 'b100'
I don't want the date in column 'b' change daily though the date in 'c7'
changes daily. It should remain static.
Please solve my problem.
Thank you.
-----Original Message-----
From: Zujar Shabbir Kanchwala
Sent: Thursday, April 11, 2013 8:47 PM
To: accessindia@accessindia.org.in
Subject: Re: [AI] Iteration information in excel
The Iteration option is useful for performing calculations on a cell
containing circular reference repeatedly. If a cell refers to itself
in a formula then it is said to have a circular reference. For example
, the cell B3 containing the below formula is said to have a circular
reference:
=IF(B3 < 1000, B3 + 50, B3 + 100)
The maximum value 100 in the Options dialog box means that the
calculation "B3 + 50" or "B3 + 100" is performed 100 times every time
the worksheet is calculated. Pressing the F9 function key initiates
calculations on the worksheet. The above formula result would be 9000.
Press F9 and you would see the result in B3 change to 19000.
If you change the value from 100 (default) to 1 then the calculation
would be performed only once. You would see the initial value of the
formula as 50 followed by 100, 150, 200 and so on.
Hope this makes sense!
On 4/11/13, Mukesh <mukeshbaviskar....@gmail.com> wrote:
Dear friends,
There is a maximum iteration option in excel option- formula – maximum
iteration 100. I want to know the use of this option which is set to
hundred
by default. If I will change it to 1 what will be the effect of it in
spreadsheet .
Thanking you in anticipation.
Regards
Mukesh Baviskar
Mobile: 9403161157
Skype id: mukeshbaviskar
Blog:
http://mukeshbaviskar.blogspot.com
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
--
Best Regards,
Zujar...
An optimist laughs to forget, whereas a pessimist forgets to laugh!
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Regards
Mukesh Baviskar
Mobile: 9403161157
Skype id: mukeshbaviskar
Blog:
http://mukeshbaviskar.blogspot.com
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
