|Jeez mike.. I know they arent numbers.. It was for REFERENCE.|
My job is to build masts that hold railway electrification.
The masts are allocated in increments of 400.
The mast allocation starts like this, 1400mm then it goes up in increments of 400mm. I dont know why it is like this... probably because the people that make it need it like that.
The minimum value of height for this project is 7300mm.
So, I have a calculation that gives me a value of X (This is algebra). Now X is not a number, but it symbolises a number. (Similarly to what I was doing with A and B)
So the value X needs to be incremented to a value of 400 like you did perfectly earlier.
Your formula points to CELL A1. I want CELL A1 to say error when it is less than 7300mm. This may not seem to matter to you, but this value will carry over to other formulas. If it gives an error, then I will know where the problem is and I can adjust other allocation accordingly.