Forum Discussion
MelissaHammond
Jul 29, 2021Copper Contributor
Writing an IF Formula in Excel with multiple conditions over multiple cells
I am trying to write an IF formula in excel that has multiple conditions from multiple cells. Columns C, D, E, & F are conditional formatted so that if the value in each of them is <300 the cell fil...
- Jul 29, 2021
Thanks. In the sample workbook in your first post in this thread, the data began in row 10, so I posted a formula for row 10.
But in your 'real' workbook, the data begin in row 11, but you still used the formula for row 10. Hence the result referred to the wrong row.
See the attached version.
MelissaHammond
Jul 29, 2021Copper Contributor
HansVogelaar
Jul 29, 2021MVP
Thanks. In the sample workbook in your first post in this thread, the data began in row 10, so I posted a formula for row 10.
But in your 'real' workbook, the data begin in row 11, but you still used the formula for row 10. Hence the result referred to the wrong row.
See the attached version.
- MelissaHammondJul 30, 2021Copper ContributorThank you Hans!! Something so small like that can easily be overlooked (as it obviously was by me, lol)...You've been a definite help!!