I will just lay out my problem very specifically because I'm not exactly sure how to ask in any other way
. In my sheet C15 =(J3*A3)+(J4*A4)+(A9)+(A10*0.25). That part is working fine. What I want to do is increase A9 by one if C15 >1 and decrease A9 by one if C15<1. This may vafe to be repeated many times to get C15 within the accepted range, and I only want it to increase or decrease in increments of 1.
Maybe the question gave it away, but I am just learning excel. It seems like my major problem is that A9 is a component of C15. Any help would be great. Thanks in advance
. In my sheet C15 =(J3*A3)+(J4*A4)+(A9)+(A10*0.25). That part is working fine. What I want to do is increase A9 by one if C15 >1 and decrease A9 by one if C15<1. This may vafe to be repeated many times to get C15 within the accepted range, and I only want it to increase or decrease in increments of 1.Maybe the question gave it away, but I am just learning excel. It seems like my major problem is that A9 is a component of C15. Any help would be great. Thanks in advance
