Trying to change a cell formula

  • Thread starter Thread starter TSchwab
  • Start date Start date
T

TSchwab

I have a spreadsheet that was given to me. It's a weight barloading sheet
and the formula has been calculated so that the starting weight is 65 lbs. I
need to change that to 55 but when I do that it recalculates all the cells
and comes up with minus weights to load. Also, he had put in there an
true/false value which then makes it come up false. I need help figuring out
what to change in that formula so it will calucate as true. Here is the
first line of the spreadsheet.

A B
Total Weight per side 100s 45s 25s 10s 5s
65 0 0 0 0 0 0

2.5s Total
0 OKAY

Here is the formula for the true/false value:
=IF(((C2*100+D2*45+E2*25+F2*10+G2*5+H2*2.5)*2+Input!$B$1+Input!$B$2) <>
A2,"Not enough weight", "OKAY")
 
It isn't clear to me how the author set up this sheet originally, but I can
see how I would do it. Seems to me the minimum weight that the sheet SHOULD
be able to deal with is the weight of the bar itself with no weights on it.
That should be in a cell somewhere, not hardcoded into the formula, so that
you can change it as easily as possible. Likewise the masses of the weights
you put on the bars: Rather than hardcoding them into his formula, they
ought to refer to the actual values found in row 2.

However, unless you're willing to take the trouble to look at this
spreadsheet and learn what it does - which I think will repay you in the end,
by the way, so you should consider it - take a look at the part of the
formula that refers to Input!B$1$ and Input!B$2$. "Input" is the name of
another sheet in the same workbook, and the formula looks at B1 and B2 in
that sheet. Those are apparently minimum weights adding up to 65. You want
to change the minimum, start by looking there.
 
Back
Top