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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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