Forum Discussion
Writing an IF Formula in Excel with multiple conditions over multiple cells
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.
I don't understand either...in your example, it works, but when I applied it to mine, it did not.
Check out the Screenshot I took.
Could you attach a copy of your workbook instead of a screenshot? You can delete everything that is not relevant to the problem.
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.