View Single Post
 
Old 09-02-2014, 11:23 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Perhaps I don't understand. By "after the field changes" do you mean "after the result in A1 changes"?

If so, it works fine for me. When I double-click in another cell (other than A1 and A2), the rand() formula recalculates. If the result is less than 0.1, then the result in A2 becomes 1. Otherwise, the result in A2 is 0. A2 will equal 1 about 10% of the time.

Here is a my file. I made the condition "<0.5" so the condition will be met more often. If I am misunderstanding, please clue me in.
Attached Files
File Type: xlsx Book1.xlsx (9.0 KB, 8 views)
Reply With Quote