Automatic Counter

[Parth]

Hi,

I want to make automatic counter in Excel. Following are the conditions.

1) In A2 cell it should continuous count 0 to 100.
2) Whenever the count is 0 to 10 and 51 to 60, then B2 cell should display YES else it should display NO on any other number.

Please assist ASAP.

 

[bensonsearch]

Hi,
is the sheet to be used while its counting? ie can we pause excel?

 

[Parth]

Yes, the sheet is to be used while counting.

 

[bensonsearch]

and do you want it to be 100 secs or just count to 100? if count to 100 it would go rather fast

 

[Parth]

It should be 100 secs, so that we can observe the change.