Forum Discussion
Formula Help
Hello! First time posting here. While I have used excel and love using it, I cannot figure out this formula/what the best route would be. At this time, I want if one cell shows this text, fill i...
Thank you for this explanation! However, I do not believe this will fit in the sheet I am working on. I apologize if I was unclear or am not understanding your explanation.
Based on the photo provided, The information from cell BC, and below, can change based on what is inputted in a different sheet. For the current info in BC3, I would like G3 through AN3 to be filled with the info seen in cell C3. However, if the info in BC3 were to change to “Early,” I would like cells D3 through AK3 to be filled with the info seen in cell C3. Not quite sure how to do this and when I entered an IF formula that I thought would work, I received an error. Any further assistance or advice would be appreciated!
Based on the photo provided, The information from cell BC, and below, can change based on what is inputted in a different sheet. For the current info in BC3, I would like G3 through AN3 to be filled with the info seen in cell C3. However, if the info in BC3 were to change to “Early,” I would like cells D3 through AK3 to be filled with the info seen in cell C3. Not quite sure how to do this and when I entered an IF formula that I thought would work, I received an error. Any further assistance or advice would be appreciated!
Belle324 Perhaps like in the attached file? I've used a small table where you set the shift start and end times. Cells in AZ and BA are updated based on the selected shift in AY.