Previous Topic Next Topic

Recalculation

Solved/Closed
endoox Posts 3 Registration date Monday 6 August 2018 Status Member Last seen 9 August 2018 - 7 Aug 2018 à 09:47
endoox Posts 3 Registration date Monday 6 August 2018 Status Member Last seen 9 August 2018 - 9 Aug 2018 à 12:58
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.
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
7 Aug 2018 à 11:30
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 3 Registration date Monday 6 August 2018 Status Member Last seen 9 August 2018
7 Aug 2018 à 12:41
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 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
9 Aug 2018 à 11:20
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 3 Registration date Monday 6 August 2018 Status Member Last seen 9 August 2018
9 Aug 2018 à 12:58
Hi TrowaD
Thank you for your attention. I will try the advice.
Best Regards,
Endoox