Hi Excel experts,
This is what I want to do: if cell b3=SAME, then fill cells d3:d52 with the contents of b4 (which would just be a number). If b3 does not equal SAME, then I want to enter numbers into d3:d5 manually on the keyboard. I thought I could do this with an IF statement and have tried several different formulas, but I can't get it to work. Obviously I am sort of a novice and would really appreciate any information on how to accomplish this task. Thank you very much.
This is what I want to do: if cell b3=SAME, then fill cells d3:d52 with the contents of b4 (which would just be a number). If b3 does not equal SAME, then I want to enter numbers into d3:d5 manually on the keyboard. I thought I could do this with an IF statement and have tried several different formulas, but I can't get it to work. Obviously I am sort of a novice and would really appreciate any information on how to accomplish this task. Thank you very much.