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