Hello All,
I have a grid, rows are profit per unit, starting a 500 and going down to 3,175 in increments of 25. The columns are units starting at 25 and going to 250, incrementing by 5.
I want a formula to calculate a number that is always greater than the cell to the left of it, and always greater than the cell above. Can't go over 40 though. Each column will start slightly above 0 and max at forty.
Any ideas?
I have a grid, rows are profit per unit, starting a 500 and going down to 3,175 in increments of 25. The columns are units starting at 25 and going to 250, incrementing by 5.
I want a formula to calculate a number that is always greater than the cell to the left of it, and always greater than the cell above. Can't go over 40 though. Each column will start slightly above 0 and max at forty.
Any ideas?