Function Arguments results differs from cell

[jupops]

Good Afternoon

Could you plesae help. I have a max formula, which will look at a worksheet to give me the maxium time if 2 criteras are met.

If you look look at the fomula result in Function Argument, the correct result is shown, but the result in the cell is showing a different answer.

I ensured that the cell format was the same as the looked up cell and can't understant why it will not show the resul it calculated, Have you any suggestions.

The formula is: =MAX(IF(spool!A2:A4300=A2,IF(spool!E2:E4300="LOGOFF",spool!D24300)))

Regards

Jupops

 

[xlhelp]

Enter it as an array formula. That is, type in the formula, then hold CTRL & SHIFT and press ENTER.

Another Victim of the recession