Recalculation [Solved]

Posts
4
Registration date
Monday August 6, 2018
Last seen
August 9, 2018
-
Hi friends
I need your help to do an operation. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. ( for example : A20 , A25 , B40 , B45........ ) when all 20 of these cells = 1, the L18 cell becomes "OK" and the calculation must stop. I press f9 once for each calculation until the L18 cell is "OK". Once I press the f9 key, the calculation starts and the calculation is done when the L18 cell is "ok". I can not speak English enough. I hope I can tell you my problem. and I hope I did not disrespect. Thank you in advance for your help.
See more 

Your reply

1 reply

Posts
2441
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 18, 2018
0
Thank you
Hi Endoox,

Not sure why you would use manual calculations and then use the f9 key, but if you are looking for a formula, then try this one:
=IF(AND(A20=1,A25=1,B40=1,B45=1..........),"OK","Change")

Best regards,
Trowa
endoox
Posts
4
Registration date
Monday August 6, 2018
Last seen
August 9, 2018
-
Hi TrowaD ,
Thank you so much for your help. I guess I could not tell. 20 cells, referring to the relevant table. it changes to 0 or 1 accordingly. when all cells are 1, L18 cell equals "ok". If all cells are not 1, the L18 cell equals "False". I press the f9 key for each calculation until the L18 cell is "ok". What I can not do is; If you press the f9 key once, continue until the L18 cell is "ok". in other words; Once you press the f9 key, the calculation is done when the L18 cell is "ok". I'm using google translate. I hope that I express what I want. Thank you very much. Best Regards
TrowaD
Posts
2441
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 18, 2018
-
Hi Endoox,

When I hit f9 either the entire sheet or the entire file is recalculated.

When english is failing to get your point across, try using pictures/screenshots to do so.

Best regards,
Trowa
endoox
Posts
4
Registration date
Monday August 6, 2018
Last seen
August 9, 2018
-
Hi TrowaD
Thank you for your attention. I will try the advice.
Best Regards,
Endoox
Respond to TrowaD