Forum Discussion
Problem with a Excel formula
Hi Not sure what I've done but the only thing I've changed is the number of cells/ lines in the range from: =MAX(IF('Draw Results'!C1:C2248={3,4},'Draw Results'!D1:D2248)) to =MAX(IF('Draw Results'!...
Hi Steven
Please re-check your updated formula are array ones
Hi Sergie. How do I do that?
Hi Steven,
That's just an assumptions - your formula always returns zero, other words always returns FALSE, thus most probably doesn't work on entire range, that could means it's entered not as array formula.
Stay on the cell with your formula, shift into cell edit mode (F2 or double-click) and Ctrl+Shift+Enter then. {} shall appear.
To check how it works in ribbon Formulas -> Evaluate formula and follow the steps. But better to shorten your range for such tests.
Hello again. ive tried that and even shortened the range but it is still the same. Not sure what iam looking at when i do the evaluate thing.