Previous Topic Next Topic

Recalculation

Solved/Closed
endoox Posts 3 Registration date Monday August 6, 2018 Status Member Last seen August 9, 2018 - Updated on Aug 7, 2018 at 05:18 PM
endoox Posts 3 Registration date Monday August 6, 2018 Status Member Last seen August 9, 2018 - Aug 9, 2018 at 12:58 PM
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 response

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