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+Inpu t!$B$1+Input!$B$2) <
A2,"Not enough weight", "OKAY")