I've been wracking my brain for the last 4 or 5 hours, trying to write myself a formula in excel. I stumbled across this site, and hope you can help me. I appologize if I'm in the wrong sub-forum, but it seemed appropriate.
I have a consecutive list of sequential numbers, 1 through 27 (all whole numbers, and all are present and accounted for). I need to write a formula so that I can plug in any number (X), and 1 = 8X, while 27 = 1X, with a perfectly sloping line in between.
i.e. If I plug in 50, then 1=400 and 27=50
I know this has got to be simple, and if I could remember far enough back to high school, or if I had paid attention in high school, I probably would have known what to do.
Thanks,
Jimmy
I have a consecutive list of sequential numbers, 1 through 27 (all whole numbers, and all are present and accounted for). I need to write a formula so that I can plug in any number (X), and 1 = 8X, while 27 = 1X, with a perfectly sloping line in between.
i.e. If I plug in 50, then 1=400 and 27=50
I know this has got to be simple, and if I could remember far enough back to high school, or if I had paid attention in high school, I probably would have known what to do.
Thanks,
Jimmy