新聞財經娛樂♬資訊 News Economy

I am using Office 365 / Excel
I need this to work in an IPAD Air,  so I presume VBA is out of the question.

Here is a formula.  Here is a problem.  The following formula will be found in B1, B2, B3 etc... referencing the cell  to the left.

=IF(A1=TRUE,CHOOSE(RAND()*10+1,1,2,3,4,5,6,7,8,9,10),"")

As things are now,  if A1 = true, then the value in B1 will change every time a sheet calculation is done, no matter what the trigger for the sheet recalculation.

 I want the value of B1 to recalculate only when the cell A1 has exited the edit mode.  

Thank you.

There is a third option for Calculation - "Automatic except for Data Tables".

Maybe setting your range to a Data Table and using this option will prevent it from Recalculating.

Thanks
Rob H