Hey all, I'm new here, but I've seen some really helpful stuff, and am hoping to have some information I saw in an earlier thread built on.
Another user had some issues with using IF statements, and I think I can use them to solve the problem I have, but I'm not sure how.
What I would like to do, is have users (some employees of mine) input a number into a cell, for example the number "5", and instead of that cell accepting this at face value, I would like Excel to instead populate that cell, and the next four cells with a "1".
An example would be this (manually inputted of course).
4579522651.png
So Cell A9 would be "incorrect", and Cells C9-13 would be correct.
I believe using an IF statement will accomplish this, but I'm not sure how to proceed with that information.
I would be eternally grateful for any info, or help you wonderful people could provide!