A correct IF function doesn't show the function's result in cell

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,Variations!$C$7:$C$246))=0,"",MAX(IF(Variations!$B$7:$B$246=POs!B92,Variations!$C$7:$C$246)))

Please help

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" <Michael@discussions.microsoft.com> wrote in message
news:7CD5130C-FD9B-4575-BCEB-25DFB4DA9528@microsoft.com...
> 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,Variations!$C$7:$C$246))=0,"",MAX(
IF(Variations!$B$7:$B$246=POs!B92,Variations!$C$7:$C$246)))
>
> Please help