View Single Post
  #1   Report Post  
MMV
 
Posts: n/a
Default Formula window displays correct answer while cell displays incorre

The formula : =SUM(IF($O$6:$O$10=O10,1,0)) in the formula window diplays the
correct answer of 2.000. The range does have 2 numbers that are greater or
equal to 010. The cell were the formula resides displays 1.000. Unable to
figure out why. Formula does work in previous year worksheet.