Hi, just wondered if anyone could help me.
I have a formula in excel by where if a cell is a particular negative number then a sum of values is produced. The numbers I am working with though range from negative 3 (-3) through to plus 3 (+3). The formula isn't recognizing what is negative what is positive? Can anyone help me out with that? I am using the following formula:
=IF(AND(W4="AVERAGE",U4=-2.7),SUM(F4,'Predicted Height Chart'!C11))
I have a formula in excel by where if a cell is a particular negative number then a sum of values is produced. The numbers I am working with though range from negative 3 (-3) through to plus 3 (+3). The formula isn't recognizing what is negative what is positive? Can anyone help me out with that? I am using the following formula:
=IF(AND(W4="AVERAGE",U4=-2.7),SUM(F4,'Predicted Height Chart'!C11))