Enter a value in one cell, the other cells update

Please open attachment.Excel Help.pdf
I need to enter a value in B6 and then A1:A4 update based on the value in B6
the values in A1:A4 will be different based on the number of drawers.
I know this is vague. Basically in need to enter a number in B6 and the other cells calculate.

Originally Posted by FDibbins

if you have the excel file, why do you upload a pdf instead? pdf's are pretty much impossible to edit, and I doubt any1 would want to retype your data for you.

Please upload a sample workbook, thanks

I want to create a workbook that will calculate the size of the drawer fronts based on the overall height of the cabinet (30.25 in this example) and the quanity of drawer fronts (4 in this example). The reveals will always be .25 as shown in pdf. but the amount of reveals are based on the amount of drawer fronts.

The value in B6 is different every time and the amount of drawer fronts are different, could be 2,3 or 4 drawer fronts.

Thank You

Originally Posted by alansidman

What is the logic for the cells A1:A4 to calculate to? In your current example, the sum of A1:A4 equals 29.25 and not 30.25 as shown in your picture. What relationship do you want the cells to have? Tell us in simple english how this is to happen.

I want to have A1,A2,A3&A4 plus the .25 reveals in between the drawer fronts to = the overall height of the cabinet (B6)
the overall cabinet height changes and the quantity of the drawer fronts change.

Could be I need a another cell with the quantity of drawer fronts in it and do the calulations with the overall height of the cabinet????

Thank You

The bottom drawer will never have a bottom reveal. The top drawer will always have a reveal above it of .25. The drawer sizes are based on the architects drawings. Could be 2,3, or 4 drawers per cabinet.

If I could enter the cabinet height and the amount of drawers and it would calculate the drawer sizes, that would be great. The problem is many times the drawers are different sizes, say on a 3 drawer cabinet the top drawer could be 5 and the other 2 are equal, or they could all be different.

Thanks For your help

Originally Posted by FDibbins

Im afraid that if you dont know what height the drawers will be, excel will not be able to know that either. excel is awesome at calculating stuff, but it MUST have rules and logic to base its calcs on.

let's put it this way. if you did not know the draw heights, or even the ratio of drawer heights, or the qty of drawers, how would you go about solving this manually?

I would know what the top drw. height would be, but it is different on every project and I would need to enter a number say 6 for the top height and would like to have excel figure the rest for a 2 drawer bank, 3 drw. bank and a 4 drw. bank of drawers.

Do I need to create a worksheet for each one of the banks of drawers and then I can get help with the formulas?

Thanks