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

M

Michael

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
 
B

Bob Phillips

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)
 
Top