pI have a sheet in my workbook where every computed value is entered into a cell as “0” even though when I use the function tool to check the function, the correct value is shown. It happens with every cell on the sheet. ????

One clue. This sheet was imported from another workbook. To break the links to the other workbook I used the trick of replacing all of the “=“ characters with something else, importing the sheet, then putting the = characters back in.

But, according to the function tool, the equations get the correct values!

Here is just one example of a function that gives the correct result in the tool,but puts 0 (zero) into each cell where is is used:

=IF(Parameters!R[6]C[-1]<>””,Parameters!R[6]C[-1],””)

ps ANYTHING with an equal sign (e.g., =5*6) gives a zero in the cell ????

Anybody have any ideas about what is going on on this sheet that makes it refuse to accept computed values??

One clue. This sheet was imported from another workbook. To break the links to the other workbook I used the trick of replacing all of the “=“ characters with something else, importing the sheet, then putting the = characters back in.

But, according to the function tool, the equations get the correct values!

Here is just one example of a function that gives the correct result in the tool,but puts 0 (zero) into each cell where is is used:

=IF(Parameters!R[6]C[-1]<>””,Parameters!R[6]C[-1],””)

ps ANYTHING with an equal sign (e.g., =5*6) gives a zero in the cell ????

Anybody have any ideas about what is going on on this sheet that makes it refuse to accept computed values??

Last edited: