Have you array-entered, it, that is, it should be committed with
Ctrl-Shift-Enter, not just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Michael" wrote in message
...
I have inserted an IF function in one cell and it shows on the function
box
the correct result but still when closing the function box, the result
doesn't appear in the cell
Here is the function used


=IF(MAX(IF(Variations!$B$7:$B$246=POs!B92,Variatio ns!$C$7:$C$246))=0,"",MAX(
IF(Variations!$B$7:$B$246=POs!B92,Variations!$C$7: $C$246)))

Please help