I am trying to create a formula that will keep the cell value from another
workbook but if the value in the cell in -0.15, then change it to 0.00. I
did get it to change the -0.15 to 0.00, but if it is more than -0.15, it does
not return the cell value from the other workbook. I would appreciate any
help. Thanks,
--
jeannie v

On Sat, 15 Jul 2006 17:52:02 -0700, jeannie v
wrote:

I am trying to create a formula that will keep the cell value from another
workbook but if the value in the cell in -0.15, then change it to 0.00. I
did get it to change the -0.15 to 0.00, but if it is more than -0.15, it does
not return the cell value from the other workbook. I would appreciate any
help. Thanks,

=IF([Book2]Sheet2!$A$1=-0.15,0,[Book2]Sheet2!$A$1)

or

=([Book2]Sheet2!$A$1<-0.15)*[Book2]Sheet2!$A$1


--ron