IF statement only filling out first cell

I have a stupid question 😅 so I've been following some tutorials, and one mentions IF statements. I wrote it out exactly the way it was in the tutorial, and am using the very same file that is being...

excel

Formulas and Functions

mtarler
Jun 13, 2022
What version of Excel are you using? The dynamic array functionality you saw and are trying to use was introduce in 2021 I believe so if you have an older version you will need to do the drag down technique. In order to not get erroneous values when you drag down use the$ character to "lock" particular reference parts like: $A2:$A5 will lock column A even if you copy it right or left while A$2:A$5 will lock rows 2-5 even if you copy up or down and $A$2:$A$5 will lock both rows and column.
That said in your formula you just need =IF(D2>30, "Old", "Yound") and drag down.

mtarler

Silver Contributor

Jun 13, 2022

What version of Excel are you using? The dynamic array functionality you saw and are trying to use was introduce in 2021 I believe so if you have an older version you will need to do the drag down technique. In order to not get erroneous values when you drag down use the$ character to "lock" particular reference parts like: $A2:$A5 will lock column A even if you copy it right or left while A$2:A$5 will lock rows 2-5 even if you copy up or down and $A$2:$A$5 will lock both rows and column.
That said in your formula you just need =IF(D2>30, "Old", "Yound") and drag down.

mandy21
Copper Contributor
Jun 14, 2022
mtarler OOH that makes a lot of sense, thank you! I'm at my college's computers and they have 2019, so that makes sense. Thank you so much! 🙂

Forum Discussion

IF statement only filling out first cell

Resources