View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GARRYPRINCE
 
Posts: n/a
Default negative numbers as a zero

AFTER CREATING A FORMULAR USING 3 CELLS I NEED TO MAKE SURE THAT ANY NEGATIVE
NUMBER IS SHOWN AND CALCULATED AS ZERO WHICH I KNOW HOW TO DO BUT I NEED TO
ALSO BE ABLE TO ENTER A MAXIMUM EG

=MAX(C4-D4,0) WILL GIVE ME A ZERO NUMBER BUT HOWE DO I CREAT A MAXIMUM
i WANT THE ANSWER NOT TO EXCEED 4300 AND THE MINIMUM TO BE 0
THANKYOU