View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeannie v jeannie v is offline
external usenet poster
 
Posts: 127
Default KEEP CELL VALUE UNLESS IT IS -0.15 THEN ENTER 0.00

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