multiples

Hi Everyone, I'm new here and very much a novice when it comes to Excel. Trying to create an order form in Excel and in some instances, the customers are only allowed to order quantities that are a specific multiple. For instance, some products can only be ordered in multiple of five. While...

Any help would be appreciated. I have a dynamic table of dates. Each column references entire production cycles and each row the cycle stages, with the top row being the start and the bottom the end. I am trying to create a "day calendar" on new sheet with the first column listing every day from...

Hello, Could anyone help me to shorten this sub, I wish to enrol the use of a command to determine multiples, but I don't know how, an 8 year break from VBA has left me feeling rather rusty. :laugh: Sub ScrollDayLabel() ' ActiveSheet.Shapes("TODAYBOX").OnAction = "ScrollReset" '...

I need a formula which as an example, when A1 is 6, then it multplies A2 by 8.0186 and puts this value in cell A3, however if A1 is 8 then it multiples A2 by 14.2554 and places the value in A3 Thanks Everyone

Hiya peeps, So I'm trying to work something out. In column A I have staff names. In row 1 I have the days of the week. Column B is titled Monday Column C is titled Tuesday and so on. So say for example in cell B1, I have written down 88 (this means that staff 1, is working 8-8 on Monday. I've...

I am performing an analysis where I have a value that grows at an unknown, changing rate. My example has two columns. The first is periods of time (t), incremented by 1. The second contains the increasing value. The value (i) at t0 = 1. For example: <tbody> 0 1.00 1 1.05 2 1.07 3 1.16...

Hello everyone! Thanks in advance for any help you can offer me. I'm trying to create a budget that autopopulates based on info entered into my checkbook. I have categories attached to each checkbook entry. I want the budget to create a sum based on both the category and date. So for each...