Recalculation [Solved/Closed]

Report
Posts
4
Registration date
Monday August 6, 2018
Status
Member
Last seen
August 9, 2018
-
endoox
Posts
4
Registration date
Monday August 6, 2018
Status
Member
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.

1 reply

Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
396
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
Status
Member
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
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
396
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
Status
Member
Last seen
August 9, 2018

Hi TrowaD
Thank you for your attention. I will try the advice.
Best Regards,
Endoox