This Formula:

=(IF(E69/50<1,1,E69/50)*3*IF(E69<=0,0,1)*IF(A69=1,0,1)*IF(A69=10,0,1)* IF(A69
=20,0,1))*IF(A69=0,0,1)

Produces a wrong result when I use code to put the numbers in cells A and E.

I didn't write the formula, my job is to produce some fast and fancy (four
levels deep) sorting, but when I write all the data to a recordset and then
re-organize the rows, this formula (which is not transposed, all it's
references are in the same row) produces a wrong result.

For instance with 1 in cell A and 56 in cell E, the answer should be 0, but
it produces 3. It works fine when typing values in by hand.

I've checked that the number formatting of the cell is not being harmed, all
cells are keeping their correct format.
(Number, 0 decimals is what the client wants)

Bob