KEEP CELL VALUE UNLESS IT IS -0.15 THEN ENTER 0.00

J

jeannie v

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,
 
R

Ron Rosenfeld

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,
Click to expand...

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

or

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


--ron
 
Top