It does seem to recalculate correctly in my workbook. However to check, i think it's better to change the value in A3 instead of A2. Because the corresponding value in B2 (5) is the biggest in range B1:B5, the conditions implied in the formula leave the results in C1, C3, C4, C5 unchanged, as they should i think.