Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to change a cell formula
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") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to change a cell formula
Not enough info. Send me the worksheet.
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "TSchwab" wrote in message ... 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") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to change a cell formula
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. --- "TSchwab" wrote: 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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
How to change a tab name with cell reference and formula? | Excel Worksheet Functions | |||
Change color in cell if contains formula? | Excel Discussion (Misc queries) | |||
How to change a formula in one cell and have these changes appear | Excel Worksheet Functions | |||
How to change a formula in one cell and have these changes appear | Excel Worksheet Functions |