Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by peispud
at 2024-05-24 17:22:04
ModifyPoint:500 Replies:8 POST_ID:828922USER_ID:11822
Topic:
Microsoft Excel Spreadsheet Software;;
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.
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.
Author: peispud replied at 2024-05-28 15:31:48
I haven't tried Rob Henson's solution yet, the this is the kind of innovative idea that I was hoping for.
I will try this. Thank you all
Aubrey
I will try this. Thank you all
Aubrey
Accepted Solution
Expert: Rob Henson replied at 2024-05-27 02:17:30
500 points AVERAGE
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
Maybe setting your range to a Data Table and using this option will prevent it from Recalculating.
Thanks
Rob H
Expert: Glenn Ray replied at 2024-05-25 14:52:16
Unless there is an option to change the calculation mode from "Automatic" to "Manual" AND there is some keyboard shortcut equivalent to the [F9] key, I don't think this will be possible without VBA.
Author: peispud replied at 2024-05-25 14:25:47
set the value of A1 = true
Set the following formula in B1 =IF(A1=TRUE,CHOOSE(RAND()*10+1,1,2,3,4,5,6,7,8,9,10),"")
The worksheet will recalculate and cell B1 will resolve to a value.
Now go to cell D5 : Enter any new value there and watch cell B1. The value will change.
I want Cell B1 to only change when cell A1 has changed. I need to do this without VBA.
I may not get a solution to this dilemma here, but that is ok. If anyone can help with this though, that would be great!
Set the following formula in B1 =IF(A1=TRUE,CHOOSE(RAND()*10+1,1,2,3,4,5,6,7,8,9,10),"")
The worksheet will recalculate and cell B1 will resolve to a value.
Now go to cell D5 : Enter any new value there and watch cell B1. The value will change.
I want Cell B1 to only change when cell A1 has changed. I need to do this without VBA.
I may not get a solution to this dilemma here, but that is ok. If anyone can help with this though, that would be great!
Expert: duncanb7 replied at 2024-05-25 04:49:07
Is there icon for formulas on Excel?
click the Formulas tab > Calculation Options button, then check "Automatic"
Duncan
click the Formulas tab > Calculation Options button, then check "Automatic"
Duncan
Author: peispud replied at 2024-05-25 03:38:52
I will look at the MSDN article more closely when I have more time. I did have a quick look at it. In my analysis (quick read), the solution proposed there requires the use of VBA. I cannot use VBA on an Ipod Air.
I don't think that the answer is there.
Aubrey
I don't think that the answer is there.
Aubrey
Expert: duncanb7 replied at 2024-05-24 17:52:26
There is a few article about Excel recalculation in google search, there is one
at this Microsoft site.More or less is Excel2003/2007 similar to Office365/Excel for Manual
recalculation at the bottom of the page , at
http://msdn.microsoft.com/en-us/library/bb687891(v=office.12).aspx
Hope understand your question completely, if not , please point it out
Duncan
at this Microsoft site.More or less is Excel2003/2007 similar to Office365/Excel for Manual
recalculation at the bottom of the page , at
http://msdn.microsoft.com/en-us/library/bb687891(v=office.12).aspx
Hope understand your question completely, if not , please point it out
Duncan
Expert: Glenn Ray replied at 2024-05-24 17:38:08
I'm guessing setting the worksheet to Manual calculation (in Options) and then forcing a manual refresh ([F9] in Windows, same on Macs) won't work for you.
I can say that the following formula will achieve the same result in a simpler manner:
=IF(A1=TRUE,RANDBETWEEN(1,10),"")
-Glenn
I can say that the following formula will achieve the same result in a simpler manner:
=IF(A1=TRUE,RANDBETWEEN(1,10),"")
-Glenn
