View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

That won't necessarily solve the problem. If Precision as displayed is
set, and all cells are set to 2 decimal places:

A1: 1.00
A2: =A1/3 == 0.33
A3: =A2 * 3 == 0.99
A4: =A1/3 * 3 == 1.00
A5: = A3 = A4 == FALSE

In article ,
"Bernie Deitrick" <deitbe @ consumer dot org wrote:

Use Tools | Options.... Calculation tab, check "Precision as displayed"