Thread: Exel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Farnorth Farnorth is offline
external usenet poster
 
Posts: 1
Default Exel formula

I need a formula to enter into a cell, that tells it if the value of the cell
is < 0 it must show it as 0, and if the value is 0 or 0 it must show it as
the original value.
I.e. if it's a negative value - display 0
if its a positive value - display the true value
Tanja