Forum Discussion
Solved
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...
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.
Hey Hans, thanks for the reply, unfortunately, it didn't work correctly for all situations.
It works correctly for when all cell values (C-F) are less than 300, or if only 1 of the cells (C-F) is above 300, or if at least 3 of the cells (C-F) are above 300, but not when 2 of the cells (C-F) are above 300. However, if only two of the cells (C-F) have a value in them at all (example: C = 100, and E = 265, but there is no value in D or F) it put Y instead of N, and conversely (example: D = 308, and F = 482, but there is no value in C or E) it put N instead of Y.
It works correctly for when all cell values (C-F) are less than 300, or if only 1 of the cells (C-F) is above 300, or if at least 3 of the cells (C-F) are above 300, but not when 2 of the cells (C-F) are above 300. However, if only two of the cells (C-F) have a value in them at all (example: C = 100, and E = 265, but there is no value in D or F) it put Y instead of N, and conversely (example: D = 308, and F = 482, but there is no value in C or E) it put N instead of Y.
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.
