I have an old excel file I have been using, it figures the weight using the number of items I type in, some new customers are requiring me to add bolts, nuts and washers to some but not all, I have to remember to add them, and number required. I have a blank cell I just type all that in.
How would I make a cell where if hardware is required, it would add it for me
One item needs 4 bolts, nuts & washers, also we use 2 different bolt diameters, my sheet has the bolt hole size required, and the bolts needs to be a 1/16" smaller. for 7/16" holes we use 3/8" bolts, 95% of the time this is what we use, occasionaly we use 1/16" holes and 5/8" bolts.
Bookmarks