Thread: Dividing by Zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Dividing by Zero
Use a formula like

=IF(A2=0,0,A1/A2)



"TomRW" wrote in message
...
If I have 8 in A1 and 2 in A2 I get 25%.

But if I have 8 in A1 and 0 in A2 I get #DIV/0!. When I want to get 0
or 0%.

Simple remedy?

Reply With QuoteReply With Quote