Hi,
Is there a way to set a cell equal to a value without removing the equation?
The cell looks like this now:
=IF(ISERROR(D554);D553;IF(OR(D554<0,65;D548=1);D553;IF(D583=1;D554-0,01;D554)))
I want to set the value of this cell to 0,95 when someone changes the input of a cell. Then I want it to continue with the formula which is there already (it's a counter which uses iterative calculations).
Thanks you for any answers!
You cannot have a value and a formula in the same cell - it's one or the other.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hmm, okay. Is there a way where I can change a cell to be 1, then do the iterative calculations, then change it back to 0?
Sorry - I did not notice that this is in the VBA section - my mistake. Someone who is expert in VBA will be able to help you.
It is hard to visualize what you are describing.There are the Goal Seek and/or Solver utilities that will perform that kind of operation. Is that what you are looking for?I want to set the value of this cell to 0,95 when someone changes the input of a cell. Then I want it to continue with the formula which is there already (it's a counter which uses iterative calculations).
https://support.office.com/en-us/art...3-4f369d6e66c7
https://support.office.com/en-us/art...d-078f96d1652c
Originally Posted by shg
I think I figured it out. Added this code:
If Target = Range("D38") Then
Range("D548").Value = Range("AM310").Value
End If
Application.Calculate
If Range("D548").Value = Range("AM310").Value Then
Range("D548").Value = Range("AM311").Value
End If
Where AM310 is 1 and AM311 is 0. And then my cell checks if D548 is 0 or 1. When you change the input(D38) D548 is 1 and the cell restarts at 0,95, then the code triggers one calculation, which changes the cell and set the checker to 0. Then the 100 iterative calculations are done when the check is 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks