i have 13 cells in Excel that i am working with. i am trying to write a Function that will Take of cell with a given number (cell A1) and if it is <= 500 the B1 would divide by 1, if A1 is =500 but <=1000 then B1 and B2 would divide by 2 and so on in 500 increments up to 6000 where if A1=>6000 then B1 through B12 would divide by 12
Solved by F. J. in 29 mins