Thread: Divide two cells and if the number is negative display is as zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Divide two cells and if the number is negative display is as zero
I have an excell spread sheet and i am dividing two cells. Most of the
numbers are positve but some of the numbers are negative. I want to put a
formula in to all the cells that will divide the two cells and give me the
answer to one digit but if the number is negative i want it to display as 0.
Reply With QuoteReply With Quote